Opening *.mdb files without MS Access installed

Option 1. OpenOffice

  • Start OpenOffice “base” component.
  • Select “Connect to an existing database”
  • Select either Access (in top of the list) or Access 2007 (bottom of the list) database type
  • Follow instructions (tick “edit after save”)

You will be able to access data tables (nothing else)

Note: It works on Windows, but I did not succeed in Linux – neither OpenOffice nor LibreOffice seem to have the option for connecting to Access databases. Am I missing something?

Option 2. mdbtools-gmbd

In Ubuntu it is available under Office menu as MDB Viewer, after you install it as mdbtools-gmbd.

Pretty simple tool, but it lets you to see data in your tables and export it to a text file.

By the way, you can download the classic Northwind Traders Sample Database from Microsoft website.


Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s