Open Microsoft Access databases on your Mac – regardless if they are in the older MDB or the newer ACCDB format.
• view, search and export your data
• the only universal Access database viewer – supports MDB, ACCDB, MDE and ACCDE
• no hidden costs, no in-app-purchases
This app makes viewing Access file quick and easy. 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 Viewer plays nice with others: export your database as Excel files, as CSV files, convert it to SQLite, or create SQL dumps. Because all apps have their unique intricacies, the documentation includes detailed instructions for transferring your data to Filemaker, Bento, Excel, Numbers, Open Office, MySQL, PostgreSQL, SQLite and Address Book.
While MDB Viewer shows all the data stored in the database, it can not display forms or queries, and it can not modify databases.
Visit the website for even more information at https://eggerapps.at/mdbviewer/
This allowed me to open Access files on my Mac with no issues. But why not allow editing the SQL statement? You can only sort by clicking on the fieldname but it refreshes the screen and you have to scroll back to that column to reverse sort. Find is horrible. Select field contains? How do I find Nulls, or dates, or ? This is worth 5 bucks but 20 for nothing?
Solved my problem, thanks to prompt support
swmjatmac
Had a dozen Access databases to convert, most of which Access 2013 and Access 2003 on PC users computers converted. But 2 caused Access to give error messages without converting. MDB ACCDB Viewer converted 1 of those databases, which had over 14,000 records, pretty quickly to Excel, and quicker to CSV. The 2nd file would not open because was an "Access 1.0 file". The developer of MDB ACCDB Viewer, Jakob Egger, worked with me to convert that file to a newer version of Access, and MDB ACCDB Viewer converted that new file to Excel and CSV immediately. Thank you!
Amazing Product
rgrMatt
This product did exactly what I wanted — exported a large access database into a MySQL compatible dump. It is strange that the only working tool I have found for migrating .accdb files comes from a single developer who wrote a product for the Mac platform. This is well worth the $20 dollars. This will save me lots of time and surely impress my colleagues.
Works Great & Great Support
jacobwoodworker
Chose MDB Viewer wisely from many similar apps. Quickly converted 9 year-old Access files into Excel for Mac. Tech Support by the developer was offered if any problems occur. Jakob Eggerprompt was prompt and very helpful in converting a problem file. Highly recommend this useful app.
- added support for GUID (UUID) type columns
- use modern PostgreSQL quoting style when exporting SQL
- added a menu item to the Window menu for showing the main window (in case you closed it)
