[Rob Judd]

I have been given the source code for a Java app that accesses an MS-Access database using JDBC and ODBC. At Uni (on the PCs) I set up a connection to the database file using the ODBC control planel. Can I connect to the database on my iMac running 10.1.2?

[Mactoid]

You should be able to. Are you having difficulty with something?

[timster]

A lot of beginner java development manuals usually use this kind of setup, because the majority of them are on windows, and windows supports ODBC connection to Access files.

Basically whats happening here is:

Java Application -> Sun's JDBC-ODBC connector -> ODBC DSN -> Access file.

You could do this kind of work on your iMac (assuming youre using OSX), if you could find a JDBC connector that can read direct to Access files. However, I don't know of such a beast.

I would check online web resources for ways of being able to read Access files with Unix/Linux using JDBC. Then you could probably do similar procedures to get your OSX machine to read the file.

-tim

[Rob Judd]

I've looked at a couple of ways, one which looked promising was called iODBC but I couldn't find any drivers. I guess I was hoping that someone would say "here is an app that does what you need".