|
|
| Line 1: |
Line 1: |
| − | __TOC__
| + | moved to [[FAQ (Base)]] |
| − | | + | |
| − | === Do I need Java to use Base? ===
| + | |
| − | | + | |
| − | Not strictly. Base is an application which enables you to access the database of your choice - this can be local databases like flat files, dBase files, server databases like [http://www.mysql.org/ MySQL], [http://www.postgresql.org/ PostgreSQL], [http://www.oracle.com/index.html Oracle], MS SQL Server, plus every database which you have an ODBC , JDBC, or ADO driver for.
| + | |
| − | | + | |
| − | However, by default OpenOffice.org creates all-in-one database files, using the [http://hsqldb.org/ HSQLDB] database engine, which in fact is a Java database. So, if you have a [http://java.com/en/download/index.jsp Java Runtime Environment (JRE)] installed, OpenOffice.org Base will create an embedded HSQLDB database when you choose "Create a new database" in the "New Database" wizard (<code>File|New|Database</code>).
| + | |
| − | | + | |
| − | If you do not have a JRE, then the following functionality will not be available
| + | |
| − | * You will not be able to create, or open existing, all-in-one database files which facilitate the HSQLDB engine.
| + | |
| − | * You will not be able to run the table, query, form, and report wizard.
| + | |
| − | * You will not be able to connect to your database if you only have a JDBC connector.
| + | |
| − | | + | |
| − | Everything else continues to work. In particular, you can still work with databases other than HSQLDB.
| + | |
| − | | + | |
| − | | + | |
| − | [[Category:Base Documentation]]
| + | |
| − | | + | |
| − | === Can I use Microsoft Access databases (.mdb) in Base? ===
| + | |
| − | | + | |
| − | On Windows: yes. You cannot open them directly via <code>File|Open</code>, but you can access the data therein. For this, you need the [http://msdn.microsoft.com/data/ref/mdac/downloads Microsoft Data Access Components], which are available from Microsoft for free. (In Windows XP, they're already included, so you need them for older Windows versions only.)
| + | |
| − | | + | |
| − | Then, go to <code>File|New|Database</code>, choose "Connect to an existing datbase", and select the "Microsoft Access" database type from the list. On the next page, you then select the .mdb file you want to access - that's it!
| + | |
