Accessing a remote Microsoft Access database
As we access a remote oracle databse (remote-> on a different machine), is it possible to access a remote access database ? If yes, what changes should i make to the connection string below to access the same:
"jdbc: odbc:MyDSN", "username", "password"
This particular DSN (MyDSN) resides in my system.
i.e. The access database (.mdb) will remain in a different machine and will also have a corresponding DSN in the same system. What connection string should I use to access this databse from a java applcation in my machine ?
Re: Accessing a remote Microsoft Access database
I am facing an issue while connecting to ms access db in shared drive without using DSN.While debugging java compiler crashed after executing Connection statement(DriverManager.getConnection()).I am using java1.6.Can anyone help in solving this issue?