can anyone tell me the connectionstring for connecting to an ms access database over a network?

only the second part, where you specify the location of the database, is needed. i know how to specify the jet engin.

let me give an example.

to connect to a local dbs the connection string would be:

but how do i specify a database on a computer on the network?
let say this computer's name is databaseServer and the database is on the c drive?

this is OK. I figured it out. I suppose i should have experimented before posting.

in case anyone else cares the way is to specify the computer on the network. like so:


Good morning,

Please, can you give me the code to connect to the access database on a shared folder. This code didn't work for me:

OleDbConnection aConnection = new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;" + "Data Source=@//ServerName//SharedDocs//CS//db1.mdb");

What do I need to do?

Thanks in advance,

Be a part of the DaniWeb community

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