This page is outdated. You will be redirected to http://wiki.services.openoffice.org /wiki/Documentation/FAQ shortly. Use the new menu list on the right.

Documentation / User FAQ / Installation / Previous

Can OpenOffice.org Base use Microsoft Access databases (.mdb)?

On Windows: yes right now, Other OSes, supported by OpenOffice.org, require the MDBtools library that is in development and has not been released at the time of preparing this item.

So under Windows, while you cannot open them directly via File > Open, you can access the data. For this, you need the Microsoft Data Access Components (MDAC), which are available from Microsoft for free. NOTE: Windows XP already includes these.

  1. Use File > New > Database to start.
  2. Choose "Connect to an existing datbase"
  3. Select the "Microsoft Access" database type from the list.
  4. On the next page, select the .mdb file you want to access

Documentation / User FAQ / Installation / Previous