Access Db Reader 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.
Dec 11, 2013 CNET's Forum on Mac OS is the best source for finding help or getting troubleshooting advice from a community of experts. Discussions cover Mac. MDB/ACCDB Viewer lets you open Microsoft Access databases on your Mac -- regardless of whether they are in the olderMDB or the newer ACCDB format. A convenient search function lets you find what you are looking for. Double-clicking rows brings up a record window, perfect for reading long text or inspecting images. MDB / ACCDB Viewer allows you to open Microsoft Access Databases on your Mac, regardless if they are in the older MDB or the newer ACCDB format. The app lets you view, search, and export your data. As a universal Access database viewer, it supports MDB, ACCDB, MDE and ACCDE formats.
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.
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.
E-reader For Mac
In the example above, the 'Photo' column is a complex column (in this case, an attachment field).
Access Db Reader
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.