Author Topic: Mac app to open M$ Access database file?  (Read 4575 times)

Offline Texas Mac Man

  • TS Addict
  • *****
  • Posts: 1722
    • View Profile
    • http://
Mac app to open M$ Access database file?
« on: December 03, 2007, 08:00:42 PM »
I received a  file that has a ".mdb".

 
Cheers, Tom

Mac PRAM, NVRAM, CUDA/PMU & Battery Tutorial
https://sites.google.com/site/macpram/mac-p...attery-tutorial

Offline Parker

  • TS Addict
  • *****
  • Posts: 1286
    • View Profile
    • http://www.nyparty.net
Mac app to open M$ Access database file?
« Reply #1 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...
This account isn't hacked...
I'm actually back from hiatus (and its about darn time too)!

Offline Paddy

  • Administrator
  • TS Addict
  • *****
  • Posts: 13797
    • View Profile
    • https://www.paddyduncan.com
Mac app to open M$ Access database file?
« Reply #2 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.
"If computers get too powerful, we can organize them into committees. That'll do them in." ~Author unknown •iMac 5K, 27" 3.6Ghz i9 (2019) • 16" M1 MBP(2021) • 9.7" iPad Pro • iPhone 13

Offline gunug

  • TS Addict
  • *****
  • Posts: 6710
  • TS Palindrome
    • View Profile
Mac app to open M$ Access database file?
« Reply #3 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!
"If there really is no beer in heaven then maybe at least the
computers will work all of the time!"

Offline Gregg

  • TS Addict
  • *****
  • Posts: 11748
    • View Profile
    • http://
Mac app to open M$ Access database file?
« Reply #4 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
Ya gotta applaud those bunnies for sacrificing their hearing just so some guy in Cupertino can have better TV reception.

Offline gunug

  • TS Addict
  • *****
  • Posts: 6710
  • TS Palindrome
    • View Profile
Mac app to open M$ Access database file?
« Reply #5 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!
"If there really is no beer in heaven then maybe at least the
computers will work all of the time!"

Offline Gregg

  • TS Addict
  • *****
  • Posts: 11748
    • View Profile
    • http://
Mac app to open M$ Access database file?
« Reply #6 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???
Ya gotta applaud those bunnies for sacrificing their hearing just so some guy in Cupertino can have better TV reception.

Offline Xairbusdriver

  • Administrator
  • TS Addict
  • *****
  • Posts: 26388
  • 27" iMac (mid-17), Big Sur, Mac mini, Catalina
    • View Profile
    • Mid-South Weather
Mac app to open M$ Access database file?
« Reply #7 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
« Last Edit: December 05, 2007, 05:09:52 PM by Xairbusdriver »
THERE ARE TWO TYPES OF COUNTRIES
Those that use metric = #1 Measurement system
And the United States = The Banana system
CAUTION! Childhood vaccinations cause adults! :yes:

Offline sandyman

  • TS Addict
  • *****
  • Posts: 978
    • View Profile
    • http://
Mac app to open M$ Access database file?
« Reply #8 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
« Last Edit: December 06, 2007, 03:44:07 AM by sandyman »

Offline Gregg

  • TS Addict
  • *****
  • Posts: 11748
    • View Profile
    • http://
Mac app to open M$ Access database file?
« Reply #9 on: December 06, 2007, 07:31:19 AM »
Tom, do report your results. We're curious now.
Ya gotta applaud those bunnies for sacrificing their hearing just so some guy in Cupertino can have better TV reception.