Microsoft Access on a Mac

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?
Rick DangerAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

ste5anSenior DeveloperCommented:
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.
Daniel PineaultPresident / Owner CARDA Consultants Inc.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!!!

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Jim Dettman (Microsoft MVP/ EE MVE)President / OwnerCommented:
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.
Protecting & Securing Your Critical Data

Considering 93 percent of companies file for bankruptcy within 12 months of a disaster that blocked access to their data for 10 days or more, planning for the worst is just smart business. Learn how Acronis Backup integrates security at every stage

Gustav BrockCIOCommented:
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 dirtCommented:
For the next 17 hours Parallels is 20% off.
Rick DangerAuthor Commented:
Martin
Thanks - but I assume the renewals will be back to normal price thereafter
PatHartmanCommented:
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 (Microsoft MVP/ EE MVE)President / OwnerCommented:
<<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.
Gustav BrockCIOCommented:
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.
Rick DangerAuthor Commented:
Thanks all who helped. The customer cancelled in the end.
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Access

From novice to tech pro — start learning today.