I am a small business owner and I have been working and developing a property management system in Access 2017. It works great and I've invested years and sweat & tears over this system. I run Insightly, FileMaker Pro, JotForms and other Mac based business software platforms on my Mac with iOS Sierra. FileMaker Pro is the biggest pain when it comes to external connectivity where I have to use ODBC drivers that are propriety to the FMpro people and not generic like in normal Windows ODBC connections. Besides, nothing beats Access for ease of use, form design, database application design, etc without the need to learn ASP.net, SQL Server, programming, etc.
After reading this and this, I am thinking the answer to this question is simply, "No! There is no best way to run Access".
The ONLY way I've managed to run Access was to use Windows Remote Desktop, and actually run Access 2017 on a separate Windows machine. I've tried some " "Windows" emulator programs on the Mac, and frankly they just don't have the smarts for running Access 2017 in Windows, with the ability to run Macros, or VBA, which are designed into my ACCDB database file.
I hate to have to use RDT software to remote into a separate machine whether it’s on my local network or cloud based / remote.
Given that I already know I can remote out and have dismissed these options, How can I run MS Access on my local Mac with no network connection elsewhere?