How to Use Microsoft Access 2007 on a Mac

By December 22, 2010Apple

I recently converted one of my clients. He now uses a Mac instead of a PC. I set him up with a Mac Mini and he is now in the process of learning how to utilize his Mac for tasks related to his business.

The one problem I ran into while having my client switch from PC to Mac was in transferring over Microsoft Access 2007. This particular client uses Access quite often and needed to be able to use the database program on his Mac.

The latest version of Microsoft Office 2011 for Mac does not contain the Access program. None of the Microsoft Office versions for Mac contain Access. So the only way to use Access on a Mac is to use some sort of a program that allows Windows programs to run on a Mac.

The first program I tried was CrossOver. The Mac store even suggested I use CrossOver. Of all the Microsoft programs that do work with CrossOver, it seems that Microsoft Access 2007 is the one program that does not work. I didn’t realize that until after I had purchased CrossOver, but the people at CrossOver were generous and provided a full refund.

I chose CrossOver first because it was cheaper than Parallels. But when CrossOver did not work, I gave Parallels a try. Parallels worked great for Microsoft Access 2007 and my client has been able to access his Access files (.mdb) on his Mac.

Here are a few points to remember if you are going to use Parallels on your Mac to use Microsoft Access 2007:

  • You must have a version of Windows and Microsoft Office. Parallels does not come with the operating system or program.
  • You can transfer over Microsoft Access files (.mdb format) to your Mac. You may need to look around for your .mdb files within Parallels. Look for them under ‘Computer’ and try to find them in the folders within your Mac.
  • If you are a heavy Microsoft Access user, Parallels is a great way for you to be able to use the program. There are also Mac database alternatives if you would like to completely make the shift to your Mac. Either way, you can easily transition from a PC to a Mac and continue to use Microsoft Access 2007 on your new Mac.

Erik Rostad

Author Erik Rostad

Erik Rostad started EPR Creations in May 2008. He works with universities, international organizations, and executives on their online presence.

More posts by Erik Rostad

Join the discussion 9 Comments

Leave a Reply