I am part of a research project in which we heavily rely on MS Access. Unfortunately, Microsoft does not offer Access for MacOS or iOS, so I have no possibility to work on this project when being in my home office. Is there any replacement on MacOS and/or iOS to manipulate Access databases?
There is a Mac App called MDB ACCDB Viewer, which can be useful to export Access files to CSV, etc. Not a perfect solution, but may help you at least view and export data, and the app itself is not terribly expensive.
I agree, I think a VM is probably your best solution. Virtual Box is a free VM solution. I have to admit Parallels with Coherence mode is a nice solution. I do a lot of work in Windows so I have Parallels and still run Quicken for Windows in coherence mode on my iMac.
The situation is a little complex . I work for a joint research program with several locations. When using Windows in my office I use a VPN to connect to their server and then use Access to store data in the remote database. But my local copy of the Access file only serves as an interface for the remote database.
So I guess a feasible solution could be to use a VM, connect to their network and use Access within the VM.
I currently run Win10 in VirtualBox mainly because I already owned a couple of MS licenses.
Another solution I’ve used in the past, is to buy a Windows PC and connect via Microsoft Remote Desktop. Windows 10 Home costs $ $90 - $100, VMWare or Parallels is about $80. MS Remote Desktop is free.
I’ve purchased new Dell laptops for as little as $230. If you’re connecting via MRD the quality of the screen, etc. isn’t a factor. And you never have problems with your VM when you get a macOS update.