File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/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
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
Bookmark "JDBC driver for MS Access (Linux)" Watch "JDBC driver for MS Access (Linux)" New topic
Author

JDBC driver for MS Access (Linux)

Tim Bee
Greenhorn

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.

Thanks,
Tim
Jan Cumps
Bartender

Joined: Dec 20, 2006
Posts: 2532
    
  10

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
youtube channel
Ulf Dittmer
Rancher

Joined: Mar 22, 2005
Posts: 42954
    
  73
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: http://aspose.com/file-tools
 
subject: JDBC driver for MS Access (Linux)