File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
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: 2565

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: 42965
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)
jQuery in Action, 3rd edition