• Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other all forums
this forum made possible by our volunteer staff, including ...
  • Campbell Ritchie
  • Liutauras Vilda
  • Tim Cooke
  • Jeanne Boyarsky
  • Bear Bibeault
  • Knute Snortum
  • paul wheaton
  • Devaka Cooray
Saloon Keepers:
  • Tim Moores
  • Stephan van Hulst
  • Ron McLeod
  • Piet Souris
  • Ganesh Patekar
  • Tim Holloway
  • Carey Brown
  • salvin francis

How to access MS-Access(.mdb) file in java program with MAC OS

Ranch Hand
Posts: 130
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator

I have java application with database MS access(.mdb).This mdb file i can access in windows OS with mdb drivres.
But this java application i want to run on MAC operating sytem.I am not able to access .mdb file. How can i access? is there any mdb drivers to support the MAC OS??? What is the database like Ms-acees in MAC OS.???
I am waiting for reply
pls reply asap.
Thanks and regards.
Posts: 67280
Mac Mac OS X IntelliJ IDE jQuery Java
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hmmm, if I remember correctly (and this knowledge may be out of date) MS Access is not JDBC-compatible and requires the ODBC-JDBC Bridge in order to be accessed from Java. And (again this may be old knowledge) the ODBC-JDBC Bridge is not pure Java, so it may not be able to run under Mac OS.
What I'd do is to find out more about the cross-platform compatibility of the JDBC drivers you are using.
With regards to replacement databases, since OS X is a UNIX platform (unless you are using OS 9, that is) it will run most UNIX databases. I've had PostgreSQL (a favorite of mine) runnning well under OS X, and have heard that MySQL runs without difficulty as well.
If your app is written to be database independent, you should be able to swap out Access for one of these database with little difficulty.
P.S. Anyone with more current knowledge about MS Access with JDBC should jump in!
[ August 22, 2003: Message edited by: Bear Bibeault ]
Ranch Hand
Posts: 280
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Yeah I do believe you are right about needing the ODBC-JDBC bridge to connect to MS-Access. I am also not confident about an Access DB being database independent, isn't that the whole problem with Access?
Live a little! The night is young! And we have umbrellas in our drinks! This umbrella has a tiny ad:
create, convert, edit or print DOC and DOCX in Java
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!