Looking for suitable JDBC driver

[JoJ]

Does anyone know of any JDBC Driver that:

1) is FREE
2) database=MS Access 2000
3) supports getGeneratedKeys() unlike the standard JdbcOdbc
4) doesnt require a full install (a simple JAR file download just like MySQL's driver would be perfect)

Being a Java beginner, I dont know if im asking for too much. I failed at trying a couple of (Type 4) 30-day-trial thingys.

 

[timw]

I don't know of any free ones for MSAccess. Do you REALLY have to use Access? There are far better products out there for which free drivers ARE available.

You'd probably be better porting to MS Sql Server if you must use Microsoft. Your choice of drivers increases.

eg.

http://www.microsoft.com/downloads/...54-8488-481d-b46b-af29bb18e1e5&DisplayLang=en

or

http://jtds.sourceforge.net/

 

[JoJ]

Access was chosen cuz I was hoping to be productive right away. (It's portable - plus I can administer the dB myself.)

MySQL could be the eventual dB.

For now, im still in the hunt for that "zero install" JDBC driver for Access.