Java and MS Access 2000

[anku66]

I am trying to get a Java app to connect directly to an MS Access 2000 DB. I've searched for drivers and such, but had no luck making them work. (the best thing i could find was Atinav Access Driver from

http://www.atinav.com,

but I couldn't get it working.) I am running Windows 2000.

Any thoughts/ experience?

 

[rsfoley]

Well first I just have to say this (in my best Schwartznager Voice):

DUNT DO IT! ARRIGRIGH!
​

Okay, with that off my chest, if you're insistent to do this, then lets see if I can help you.

First to find the best driver for what you are trying to do, you can search Sun's list of Drivers at:

http://industry.java.sun.com/products/jdbc/drivers

They have about 11 vendors providing MS Access Drivers.

Next, I would recommend that you check out this Sun JDBC tutorial at:

http://java.sun.com/docs/books/tutorial/jdbc/

If after you have gone through the tutorial and THEN downloaded your drivers you are still having trouble then let me know your exact problem and I will see if I can be of some help.

Also I would not recommend the drivers my ATINAV, INC, they
are JDBC 1.0 drivers. You want to make sure you get JDBC 2.0 drivers, Sun has about 5 listed. Make sure they support the feature(s) you need. (DataSource, Connection Polling, RowSets, etc...)

I hope this helps you out...

Rodney

http://www.javathis.com

PS... I do not know your reasons for wanting to use MS Access and Java (That's a job for VB hehe), but you may want to consider some of the cross plateform DB solutions out there, some of which are even opens source, and some completely free for comercial use.