Hi i am using java code to connect to MS access using following url

jdbc:odbc:Driver={Microsoft Access Driver (*.mdb)};DBQ=C:/login.mdb

Now if I need to connect to the run this java code from some other machine in network then how will I write the path "DBQ=C:/login.mdb"

7 Years
Discussion Span
Last Post by Pradeeps206

You would have to place the "mdb" on a shared drive and provide the path to that shared drive/mdb.

Access is not a "remote access" capable DB. It is a file-based DB. If a machine cannot directly access the mdb file, they cannot access the Acess DB, and two people cannot access it with write access simultaneously.

Edit: If you mean that you are deploying both the app and the DB and simply want to be able to configure the "string" for the path to the url, then use a string var in that position and populate that string using Properties.

Edited by masijade: n/a


Hi ,
I am also facing the same problem.
I cant access the url of developer paradise as access to me is denied.
I thinks its an invitation only blog.
Please help.

This question has already been answered. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.