MS Access jdbc connection

[abhishek20]

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"

[masijade]

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.

[mKorbel]

are you set ODBC for this MsAccess

[masijade]

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

[mKorbel]

uuups thank you,

http://developerparadise.blogspot.com/2006/03/jdbc-odbc.html

[Pradeeps206]

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.