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"

Recommended Answers

All 5 Replies

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.

are you set ODBC for this MsAccess

That url is a DSNLess connection url, an ODBC DSN entry is not necessary.

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.

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, learning, and sharing knowledge.