Accessing a remote Microsoft Access database

[ajeeb]

Hi,
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 ?

[satkk]

If your database resides in another system, then u can do it with DSN settings,
instead of selecting your own hard drive for searching database, u can select the option network, and browse for the machine and database, click ok

[satkk]

sorry , the case was not for oracle..:(

[abeythampy]

Hi,
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?