Hello:

I'm trying to use JDBC with an access mdb that has a mdw. What is the correct connect string format in order to access the database?

Here's what I have tried:

Attempt 1:

String url = "jdbcdbcRIVER={Microsoft Access Driver (*.mdb)};DBQ=my.mdb;SystemDB=my.mdw;UID=user;PWD=p wd";

_connection = DriverManager.getConnection(url);

Attempt 2:

String url = "jdbcdbcRIVER={Microsoft Access Driver (*.mdb)};DBQ=my.mdb;SystemDB=my.mdw";

_connection = DriverManager.getConnection(url, user, pwd);

Attempt 3:

String url = "jdbcdbc:MyDsn;UID<user>;PWD=<pwd>";

_connection = DriverManager.getConnection(_connectString);

Believe me, there were many other attempts, but you get the idea. Has anyone successfully connected via JDBC to an Access database that has workgroup security?

Thanks,

Joe