
In the documentation on my website I have compiled a more detailed list of MS Access alternatives on the Mac, along with instructions how to migrate from Access. However, this app only allows you to read tables, and does not support queries or forms, or editing databases. (Disclaimer: I am the developer of MDB Viewer). SQLite is only an SQL engine, there are no forms or fancy user interfaces like in Access.įor reading Access databases, you can use MDB Viewer for Mac. Most people will prefer using it with a graphical client like Base from Menial.
SQLite is a free, bare database engine included with Mac OS X. Again, you will need to recreate most of your database design, there is no direct import of Access databases. Bento is a low-cost and more intuitive database app from the same company as Filemaker. If you want to share databases with others, you can use Filemaker server to do that. There are several websites that offer migrating Access databases to FileMaker for you for a fee. Migrating from Access to Filemaker is not trivial, and you will have to recreate most forms etc.
Filemaker has the advantage of being available for Windows as well.
FileMaker is a very comprehensive database application that can do most things possible in Access. LibreOffice on the Mac can not open Access databases. Even basic stuff like import/export is very limited in LibreOffice. Depending on your use case, you might be missing many critical features. LibreOffice, as suggested by others, contains the "Base" module, which is more or less an incomplete clone of Microsoft Access. There is no full replacement for Microsoft Access on the Mac.