aspose file tools
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

Win a copy of Head First Android this week in the Android forum!
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: 2541

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: 42956
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.
Don't get me started about those stupid light bulbs.
subject: JDBC driver for MS Access (Linux)
It's not a secret anymore!