Techsurvivors

Archives => 2007 => Topic started by: Texas Mac Man on December 03, 2007, 08:00:42 PM

Title: Mac app to open M$ Access database file?
Post by: Texas Mac Man on December 03, 2007, 08:00:42 PM
I received a  file that has a ".mdb".

 
Title: Mac app to open M$ Access database file?
Post by: Parker on December 03, 2007, 08:43:58 PM
i havent heard of anything yet.
best thing, if you can, is open it on a PC.

I kind of hope that M$ will come out with Access for mac sometime soon...
Title: Mac app to open M$ Access database file?
Post by: Paddy on December 04, 2007, 07:31:07 AM
If you have Windows installed under Parallels, VMWare or BootCamp, you can try this viewer:

http://www.freedownloadscenter.com/Busines...s/MDB_View.html

Even if you have Filemaker Pro, the data still has to be exported in order to be readable. (I've also heard of people using Excel on exported data):

http://forums.macosxhints.com/archive/index.php/t-44092.html

Obviously, if this is a complex database, any export options may make a mess of things.
Title: Mac app to open M$ Access database file?
Post by: gunug on December 04, 2007, 07:56:06 AM
I routinely use data from an Access database but I have it open in Access and cut and paste what I want into Excel.  Not a good solution for large databases!
Title: Mac app to open M$ Access database file?
Post by: Gregg on December 04, 2007, 12:10:08 PM
What about that new one, "Bento"? You can download a trial version, I'm told. smile.gif
Title: Mac app to open M$ Access database file?
Post by: gunug on December 04, 2007, 12:51:32 PM
I was going to suggest "Bento" but I don't find anything that says it will do that!
Title: Mac app to open M$ Access database file?
Post by: Gregg on December 05, 2007, 08:20:23 AM
Is there a Bento users forum yet? Or maybe an e-mail link on their web page???
Title: Mac app to open M$ Access database file?
Post by: Xairbusdriver on December 05, 2007, 04:58:07 PM
I seriously doubt that Bento would be capable of reading/using Access files since FileMaker Pro has never been able to. You might check the <Apple Forums> for a Bento group. Or maybe at one of these <FileMaker> Newsgroups or MailLists. Then, there are <FileMaker User Groups> in various parts of the country. There's probably not much activity around yet as it is still a beta product. Just remember, it requires Leopard and it is not a FileMaker Pro ( nor AW ) replacement.


Maybe you started <this specific thread>? smile.gif
Title: Mac app to open M$ Access database file?
Post by: sandyman on December 06, 2007, 03:42:40 AM
I think that we'll see "Old Nick" on ice skates before we see a port of MS Access to any platform wink.gif

The only thing that I've been able to dig up is Mac ODBC.  To use this, you will off course need to have a copy of Filemaker Pro.  It does not work with Bento, and given the nature of Bento I doubt that it ever will.

Failing that if you know anyone who uses Windows you could ask them to try
1) Export the Access database to an Excel spreadsheet
or
2) If they don't have MS Office use Open Office. Get them to use OO to export it into a spreadsheet  and then open that on your Mac using Excel.  

None of these are particularly simple or quick solutions but I can't think of anything else

Sandy
Title: Mac app to open M$ Access database file?
Post by: Gregg on December 06, 2007, 07:31:19 AM
Tom, do report your results. We're curious now.