(You will have to installed Windows.) Or to create a virtual machine on your Mac inside of which you also run genuine Windows, or a final possibility is to use CrossOver Mac which is a way of running some Windows applications on a Mac without having Windows itself. If you want to create databases from scratch, FileMaker is a good. pyodbc can only be used on Windows platform, but I am working on Mac OS X. However, you can run the Microsoft Access Windows version in a virtual machine in the Mac system created by a. I want to access the data in a Microsoft Access database. However, many of them dont allow much editing, viewing of VBA modules etc. Microsoft Access is not designed for macOS.
MS ACCESS FOR MAC FOR MAC
Really it sounds for your purposes you need 100% genuine Microsoft Access and the only way to do this is to use either Boot Camp which lets you boot your Mac in to real Windows. Microsoft Office Access is not available for Mac but there are plenty of alternatives that runs on macOS with similar functionality. Answer (1 of 2): There are several inexpensive applications that allow you to open Microsoft Access files on Mac such as MBD Explorer and even LibreOffice. FileMaker which again does not sound suitable for your needs.īeyond that there are I believe some Mac programs for 'running' Access databases but again if this is for study purposes I would suggest they also are not suitable. There are various Access 'readers' for the Mac which do not sound sufficient for your needs, there is also a tool for converting Access files to other formats e.g. Genuine Microsoft Access only exists for Windows.