JDBC driver for MS Access (Linux)

[Tim Bee]

I'm looking for a free JDBC driver that will allow me to acces a MS Access database that resides on a Windows server from a JSP application that resides on a Redhat Linx server.
Any suggestions would be appreciated.

Thanks,
Tim

[Jan Cumps]

Ms Access is not client /server, but uses your windows filesystem to access it's data. Accessing it from a linux machine is not straightforward.

There is a software package, RmiJdbc, that turns your access database into a client/server architecture. The package includes a jdbc driver that works on linux.
The access instructions are documented on their site.

Regards, Jan

[Ulf Dittmer]

If you have file system access to the MDB file, you can use Jackcess. It's not JDBC, though, but instead implements its own API.