The moose likes JDBC and Relational Databases and the fly likes JDBC driver for MS Access (Linux) Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
Bookmark "JDBC driver for MS Access (Linux)" Watch "JDBC driver for MS Access (Linux)" New topic

JDBC driver for MS Access (Linux)

Tim Bee

Joined: Apr 30, 2007
Posts: 1
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.

Jan Cumps

Joined: Dec 20, 2006
Posts: 2549

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

OCUP UML fundamental and ITIL foundation
Ulf Dittmer

Joined: Mar 22, 2005
Posts: 42958
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.
I agree. Here's the link:
subject: JDBC driver for MS Access (Linux)
It's not a secret anymore!