Editorial information provided by DB-Engines Name FileMaker X exclude from comparison Microsoft Access X exclude from comparison Description FileMaker is a cross-platform RDBMS that includes a GUI frontend. Our visitors often compare FileMaker and Microsoft Access with MySQL, Oracle and Microsoft SQL Server. Please select another system to include it in the comparison. Microsoft Access System Properties Comparison FileMaker vs. For me, the quick online “answers” are invaluable.DBMS > FileMaker vs. Using the MySQL server opens a lot of opportunities that if using Access (or something like it) exclusively simply would not be available.įinally, you’ll find a huge number of online resources available Access, Python/Pandas/Django … my hunch is there will be fewer online resources available for these other “Mac” databases–but maybe that not important to you. Instead of learning about and growing into yet another “tool”, I found great success continuing my use of Access (for pretty forms and a dwindling number of reports/queries) connected to a database server (MySQL) then using the powerful professional tools available in the world of Python/Pandas/Django, etc. Far as I know there is no real replacement for Microsoft Access on the Mac, but keep looking if you must. All this Python stuff installed inside an Anaconda (free) environment–which again is a fantastic simplification that allows a quick install and setup and allows me to focus on the data/business and not fiddling with the computer. Terrific graphics from that via Matplotlib (free). Over the years I’ve built up some very-useful automation–but in instead of using Access VBA (which I don’t really like and never did!) I use Python (free) with a Django (free) connection to the database with Pandas as the main analysis tool. Sometimes I do quick management of the data and database via MySQL Workbench (free). I simply use Access some of the time to interface with it (using ODBC) from the local and networked machines for the pretty forms (nothing better than Access) and a very few reports/label printing.
In actuality, my database (essential for my business) runs on MySQL (free) on the Mac. If you do this then you’ll have a quick/easy setup and you can focus on the database and not the new “system”. I’m quite happy with leveraging my Microsoft Access experience (Using Access since 1992) by running it inside Parallels on both my Macs.
0 kommentar(er)
