MS Access for Mac

Question

Level 1

0 points

MS Access for Mac

I have a small business and I was thinking about converting over to Mac's for the office! We currently have a PC with XP set-up! But I had just finished putting an Access database together and really like the layout, I spent alot of time putting it together. I have an iMac at home but have yet to try to open the DB there. But I just noticed last night that I don't even have Access for Mac at home and I have looked at Mactopia and there isn't a listing for Access! So is there another way to open this DB? with another program?

20" iMac Core Duo, Mac OS X (10.4.5)

Posted on Sep 27, 2006 3:01 PM

Reply

Answer 1

Sep 27, 2006 6:01 PM in response to mjtorres

Sorry, but there is no way to open an Access DB using Mac OS X.
Microsoft Access is only for Windows.

If you want to use your Intel-based Mac to open Access databases... you'll need to install Windows on your Mac using either Boot Camp, or Parallels desktop.

Reply

Answer 2

mduser63

Level 2

480 points

Sep 27, 2006 8:23 PM in response to Rich Fleming

There is a way to open Access databases on the Mac. You can do so using NeoOffice or OpenOffice.org. NeoOffice is my choice as it's (close to) a native Mac application. ( http://www.neooffice.org)

Never used the database functionality myself as I have no need for it, but it's there.

Reply

Answer 3

Sep 28, 2006 4:34 AM in response to mduser63

NeoOffice does have a database component which is similar to Microsoft Access, however is is not compatible with Microsoft Access.

NeoOffice databases use a standard dbase file format, which offers limited database functionality. It will not open a MS Access database file.
This format is proprietary to Microsoft.

http://neowiki.sixthcrusade.com/index.php/CreatingaDatabase

Reply

Answer 4

mduser63

Level 2

480 points

Sep 28, 2006 7:32 AM in response to Rich Fleming

According to the help in NeoOffice, there is a way to import Access database files, but I see other people around the web saying they've been unsuccessful in doing so. Anyway, hopefully OpenOffice.org improves on that in the future.

Reply

Answer 5

Sep 29, 2006 9:51 AM in response to mduser63

I have connected to Access DBs using OpenOffice 2.

Here's an illustrated guide: http://www.openoffice.org/FAQs/ms-access/ms-access.html

AlBook 15

Reply

Answer 6

Sep 29, 2006 11:04 AM in response to mjtorres

FileMaker Pro

http://www.filemaker.com

Reply