Microsoft Access on a Mac

Rick Danger
Rick Danger used Ask the Experts™
on
I have just completed a database project, only to be told that they want it to run on a Mac. I know I should've asked this up front, but assumed that as they didn't mention it, it was for a PC.

Being a charity, they are reluctant to use Parallels because of the cost of 10 licences.

Does anybody know of a viable, cheap solution to the problem?
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
ste5anSenior Developer

Commented:
I don't think that there is a cheap solution. When there is a server, you may host a VM running Windows and Access and use RDP to log into it. But this is limited to one user at a time.

Depending on the kind of solution and the environment: What kind of solution did the expect? A web application? A local Java application or even a native one?

Seems like you need to do it again on a working platform. When the Access application is done correctly, then you can simply move the back-end to a database server. I would consider using a web service approach for a Angular/Knockout based web application.
President / Owner CARDA Consultants Inc.
Distinguished Expert 2018
Commented:
See Run MS Office/Access on a MAC for your options.

Also, depending on the country, have they seen TechSoup.ca (CAD) / TechSoup.org (USA), ... this way software I substantially cheaper!!!
Jim Dettman (EE MVE)President / Owner
Most Valuable Expert 2017
Most Valuable Expert 2012
Commented:
As long as the mac is intel based, you can install Windows 10 and use boot camp to give you an alternative boot.   But unlike Parallels (and other emulators), you can't run the windows app and Apple apps side by side (a reboot is always required to switch back and forth).

 Maybe they can live with that, maybe not.

 If not, a RDP server is probably the best as ste5an suggested.  That's costly though and Parallels would be cheaper in the long run depending on the number of users.

Jim.
Ensure you’re charging the right price for your IT

Do you wonder if your IT business is truly profitable or if you should raise your prices? Learn how to calculate your overhead burden using our free interactive tool and use it to determine the right price for your IT services. Start calculating Now!

Most Valuable Expert 2015
Distinguished Expert 2018
Commented:
Wine may be an alternative:

How to Run Windows Programs on a Mac With Wine

but I think to recall, that in the past it had problems with Office and indeed Access. Jim may know - I've never tried.
Martin LissOlder than dirt
Most Valuable Expert 2017
Distinguished Expert 2018
Commented:
For the next 17 hours Parallels is 20% off.

Author

Commented:
Martin
Thanks - but I assume the renewals will be back to normal price thereafter
Distinguished Expert 2017
Commented:
There might be a not for profit version of Parallels.  I would look for that.

I hope the charity didn't actually pay for these macs because if they did, they wasted a lot of money.  in the 80's Apple made the decision to be incompatible with the rest of the world so why anyone would buy a Mac at three times the price of a comparable Windows device is beyond me.  Apple was a dying company until they created the iPhone.  They are still incompatible with the rest of the world but they have built quite an ecosystem of incompatible products surrounding the iPhone and have convinced clueless people that it is reasonable to spend a thousand dollars for a phone!.  I made my grandchildren purchase their own IPhones and airbooks because I refuse to support the Apple philosophy.  But like others of their age-group, they are shallow and all about labels and appearances.  At the same age, their mother wouldn't be caught dead in a pair of jeans that didn't have a Jordash label.  My contention is that a company should pay me if they want me to wear a billboard advertising their product.
Jim Dettman (EE MVE)President / Owner
Most Valuable Expert 2017
Most Valuable Expert 2012

Commented:
<<but I think to recall, that in the past it had problems with Office and indeed Access. Jim may know - I've never tried.>>

Me neither.    I haven't played with Linux/UNIX in a long time, and never in conjunction with Access.

 It's an excellent thought though and certainly worth trying in this situation.  With that said however, I believe support for Office with Wine is not all that great.  Recent versions (2013 and up) might not even work  since Microsoft changed the rendering engine in Office.

Jim.
Most Valuable Expert 2015
Distinguished Expert 2018

Commented:
It might be possible, though I wouldn't expect the install to be five-minute job:

Main  Productivity  Database  Microsoft Access  2013 (32bit)Wine HQ: Main  Productivity  Database  Microsoft Access  2013 (32bit)

I have neither a Mac nor a Linux machine, so I can't confirm.

Author

Commented:
Thanks all who helped. The customer cancelled in the end.

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial