9/24/2019 Micirosoft Access For Mac
Nov 23, 2017 Question: Q: Microsoft Access for Mac hey there, i am studying the functions of microsoft access and just found out that it is not available on mac. Is there a way to get microsoft access on mac or something really similar and having similar functions and controls.
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 and, 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?
Welcome to Ask Different!:) You may need to edit your question to clarify what you mean by 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. It's not clear what you many by this as many users have no problems using MS Access in a VM on a Mac, although it's impossible to compare with whatever it is you've developed. Another important factor to edit into your question is the model of Mac you use and its specs, as well as the emulator programs you've tried. – Nov 14 '17 at 3:10. Unfortunately you have found the conundrum Microsoft has placed before you.
There is no way to run Access natively on a Macintosh. You can try Parallels or Bootcamp to run Windows on the Mac, and then within Windows, Office Access, but that seems a little like a Frankenstein solution. I know this sounds heretical from the completely Mac-centric IconDaemon, but sometimes Microsoft wins and you have to bite the bullet and run a PC. Have you considered purchasing access (pun intended) to a co-located Windows server? Offers such a service. (No financial or other ties to Colocation America - I just Googled and this was the first company to pop up.).
![]()
Now it's easy to connect to your Microsoft Access database using your Mac! With the Actual ODBC Driver for Access, you can use Excel and FileMaker Pro to quickly and easily retrieve data from your Access database.
Available for only $39.95 per Mac. Use Excel and FileMaker Pro to Connect to Your Database You can use FileMaker Pro to create great looking reports from your Access data. And with Microsoft Excel's built-in support for ODBC database queries, you can quickly create pivot tables and charts and graphs from data in your database.
Comments are closed.
|
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |