MDB Viewer Download Buy Now Also available on the
Mac App Store

MDB Viewer requires OS X 10.6 or later. The free trial is fully functional except for export limitations.
© 2011-2017 Jakob Egger

Help Index

Viewing Access databases with MDB Viewer for Mac

Basics

When you open a database with MDB Viewer, you will immediately see a list of tables in the sidebar on the left. The rest of the window is occupied by the currently selected table.

Screenshot of MDB Viewer showing the NWind database

You can sort the table by clicking the column titles (click twice to sort in descending order).

If a table contains lots of text or images, you can open a detail window by double clicking on a row. This will open a convenient window displaying all the data in a row, even if it contains thousands of words.

Detail window for a single record

Searching

MDB Viewer has a convenient search function. Bring it up with ⌘F or by clicking the "Find" toolbar button. You have the choice of searching all columns or a specific column.

Special Field Types

MDB Viewer understands all the different field types in Microsoft Access. For a detailed overview, see Microsoft Access Field Types.

OLE fields

OLE fields are special fields that can contains files such as images. To display an image in an OLE field, simply double click the row to open the record window. If you want to extract an OLE file from the Access database, simply drag the file icon to the Finder.

Complex Columns (Attachments, multi-valued fields and version history)

Complex columns are a powerful feature introduced in Microsoft Access 2007. They are the underlying technology of multivalued fields, attachments, and memo fields with version history. A complex field contains a key that points to rows in a helper table.

You can recognize a complex column in MDB Viewer by looking at the tool tip.

A tooltip shown for a complex column.

In the example above, the "Photo" column is a complex column (in this case, an attachment field).

The complex column.

To view the attachments, select the helper table ("Contacts_Photo" in this case). The first field (starting with an underscore) contains the same key as the complex value column. In this case, we see that the first row from the "Contacts" table has 3 attachments. We can view the attachments by double clicking on the row, or export them by dragging the file icon to the desktop.

Help Index

Questions? Contact Jakob Egger.