On Feb 22, 2005, at 11:40 PM, Andrew Douglas Pitonyak wrote:
Andrew,
James Plante wrote:
Short answer: No, not even version 2 has an Access-like database <included in the program>.
Long answer: Open Office will interface with Access through ODBC. And it will also pull data from MySQL, PostgresQL, Oracle, or anything else that has an ODBC/JDBC driver. You can even use OpenOffice as an Access-like front-end for these databases. Please see the documentation at http://documentation.openoffice.org for further info. Since this is going to be CC'd to the list, the attachment below will be stripped. It's a PDF entitled Using Data Sources, and should get you started.
Jim Plante <[EMAIL PROTECTED]>
Hi Jim,
I would probably have chosen to explain the new database functionality included with OpenOffice.org 2.0 as very similar to Access, but better because besides using the new included database engine HSQLDB, you can also access another external database in a similar fashion.
What is the state of the MS Access project? I have not looked at it in more than a year.
-- Andrew Pitonyak
Tactful as always. The info I provided was misleading at best. It can be correctly characterized as just plain wrong, in light of GRS's statement that 2.0 will have an RDBMS. I had thought it was going to be simply a flat-file system. Since I use a Mac, I don't keep up with the latest merchandise from CVS. NeoOffice/J has made me lazy.
I don't know what the state of the Access project is, but I personally don't find a great deal of visual difference between OOo's forms editor and Access's. I haven't fooled with Access in years, though. I use FileMaker Pro, but I dislike its scripting language. Most desired functionality is present, but you have to dig it out; in some cases, some very creative thinking is required to accomplish the desired task. I found even a ten-year-old version of Access Basic to be much more intuitive. Both of those scripting languages, however, are blown out of the water by OOo's UNO capability.
I didn't have much trouble getting UnixODBC running on this Mac, nor did I have a significant amount of trouble linking to a MySQL test database. I would agree that having to learn SQL queries, joins, and the jargon of relational databases is quite a hill for the average user to climb.
Jim Plante <[EMAIL PROTECTED]>
--------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
