Yes, the database project has one here . There are many different detailed sections. You can do mostly the same with OpenOffice as you can with MS Access. Table design, query design, relation design, forms and reports. The big difference is that OpenOffice doesn't ship any database (only dbase) with it. You need to choose your own (MySQL, PostgreSQL, MYDB, Adabas D, Oracle, etc. or even the MS Access file). For more information look at the database project site. Please have a look at the database project FAQ . There it is described how to connect to your mdb files. This contains the answer. The documentation project covers this . Garry Knight has an excellent HOWTO for this. Like in StarOffice 5.2, you of course still can access your Microsoft Access database. Just the names and the syntax changed .... First, you need the Microsoft Jet Engine for accessing MS Access database files. It is part of the Microsoft Data Access Components MDAC. Download the latest version of this package and install it. Second, go to “Tools” => “Data Sources”, and in the dialog create a new data source of type ADO, and as URL enter PROVIDER=Microsoft.Jet.OLEDB.4.0;Data Source=<path_to_mdb_file> (The "<"/">" belong to the "variable" ?when replacing the path, this should result in something like "Data Source=C:\AllMyFiles\MyDB.mdb").
|
|||||||||||||
By any use of this Website, you agree to be bound by these Policies and Terms of Use
Oracle and Java are registered trademarks of Oracle and/or its affiliates. Other names may be trademarks of their respective owners.