wood burning stoves 2.0*
The moose likes Mac OS and the fly likes Ms access for mac os Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of OCM Java EE 6 Enterprise Architect Exam Guide this week in the OCMJEA forum!
JavaRanch » Java Forums » Engineering » Mac OS
Bookmark "Ms access for mac os" Watch "Ms access for mac os" New topic
Author

Ms access for mac os

will Rollo
Greenhorn

Joined: Aug 23, 2004
Posts: 1
I have on my 'normal' pc a database that i created with ms access. (.mde file). I now have seen the light and bought a mac. My question is this - What database programs are available for the mac and specifically, can they run this file? I would be grateful for advice - I am planning to start a small home cinema installation company and therefore to not require a over compicated program - Just need tax, invoicing and diarising etc
Warren Dew
blacksmith
Ranch Hand

Joined: Mar 04, 2004
Posts: 1332
    
    2
Filemaker Pro is probably the easiest database to work with on the Mac.

MySQL is an SQL database that is free and easy to set up; it will require some knowledge of SQL to use. PostGreSQL is another good database.

I'm afraid I don't know enough about Access to know what options there are for moving the information over - perhaps someone else can help.
Bear Bibeault
Author and ninkuma
Marshal

Joined: Jan 10, 2002
Posts: 61103
    
  66

I know of no Mac-ready database that will read the .mdb file -- whatever you choose to use (Warren's recommendations were all good ones), you'll probably need to export your data from Access and import it into the new DB.

(The rumormill has spawned a tale that Access may make it into a future version of Office for Mac, but I would not hold my breath. Even so, I think the choices in Warren's post are better options than Access).


[Asking smart questions] [Bear's FrontMan] [About Bear] [Books by Bear]
David Hibbs
Ranch Hand

Joined: Dec 19, 2002
Posts: 374
OpenOffice now has an X11 version you can run on the mac. They also have a new ODBC driver for Access on Linux... you might give it a try -- you just might get lucky. =)

http://dba.openoffice.org/drivers/mdb/index.html


"Write beautiful code; then profile that beautiful code and make little bits of it uglier but faster." --The JavaPerformanceTuning.com team, Newsletter 039.
Barbara Norway
Ranch Hand

Joined: Sep 30, 2003
Posts: 150
Hi,

Access to FM How-Tos

This link may help if you decide to convert existing Access .mdb/.mde files to FileMaker. BTW, Filemaker will be much easier to use IMHO if you just want something that has a lot of functionality already set up for you. And it comes with precreated databases/interfaces for basic functions like AR, AP, and other common record keeping apps. There is also a FileMaker Server that can run on OS X - Server version. I'm an Oracle bigot myself but I take care of FileMaker at my job here as it's also part of the mix (I think we have just about everything here )

HTH,
Barbara


farmkitty
Bill Fisher
Greenhorn

Joined: Oct 18, 2004
Posts: 1
I have pretty much the same issue. You can export your data as Excel files or as text delimited files and import them. We made the mistake of buying Filemaker Pro 7(several copies).You have to stand on your head to make things happen in FMP that you take for granted in Access. FileMaker is my first Mac software disappointment (I've owned a Mac since the original 128 in 1984). It's really code intensive and time consuming. We're looking at MySQL and I would appreciate any insights that others might be able to share.
Bear Bibeault
Author and ninkuma
Marshal

Joined: Jan 10, 2002
Posts: 61103
    
  66

I'm not too impressed with FMP myself. Prefer PostgreSQL or MySQL.
Warren Dew
blacksmith
Ranch Hand

Joined: Mar 04, 2004
Posts: 1332
    
    2
Bill Fisher:

We're looking at MySQL and I would appreciate any insights that others might be able to share.

MySQL and PostGreSQL are SQL databases, which are kind of a different animal. Don't expect really clean, slick graphical interfaces. However, for calling the database from code, say Java code, SQL databases are really the way to go.
Warren Dew
blacksmith
Ranch Hand

Joined: Mar 04, 2004
Posts: 1332
    
    2
Another possibility that might be closer to Access would be Fourth Dimension, which still seems to be in existence:

http://www.4d.com/

They were pretty good (for the time) ten years ago, though I haven't tried them recently.
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Ms access for mac os