Can I use jdbc:odbc to access MS Access database remotely?

[Bruce Jin]

My java runs on one PC and I want to access MS Access database on another PC using sun.jdbc.odbc.JdbcOdbcDriver driver.
Is this possible?
Can I do this?
connection = DriverManager.getConnection(jdbc dbc://111.222.333.444/databasename);
Thanks.

[Sam Moran]

I have a mapped drive on my PC to a server in our server room. I set up my DSN file so that it uses the mapped drive to get to the DB and then I just connect to the DB using the DSN name in the Java program. I hope this helps!

Below, BCMSDB is the USER DSN that I setup in NT DBC Connection Data Sources! It contains the information about the mapping.

  
String url = "jdbc :-o	 dbc:BCMSDB";
Connection con = DriverManager.getConnection(url, "", "");

[Jamie Robertson]

I believe you can also accomplish this by setting up a System DSN instead of a User DSN in your ODBC datasources.

[Sam Moran]

Yes, you can set this up in either User or System DSN. System would probably be a better choice.

[Bruce Jin]

Thanks a lot!
This means that I can not connect to Access DB on another PC directly using that PC�s IP like below:
connection = driverManager.getConnection(jdbc:jdbc://111.222.333.444/databasename);
I will have to set up my DSN file so that it uses the mapped drive to get to the DB.