How to access MS-Access(.mdb) file in java program with MAC OS
Joined: Apr 26, 2003
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.
"Unwise to sweat petty stuff, wise to pet sweaty stuff."
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. hth, bear P.S. Anyone with more current knowledge about MS Access with JDBC should jump in! [ August 22, 2003: Message edited by: Bear Bibeault ]
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?