Member Avatar for Ravenous Wolf

hi.

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:
c:\\localFolder\\localDbs.mdb

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?

  • 2 Contributors
  • 3 Replies
  • 455 Views
  • 6 Months Discussion Span
  • Latest Post Latest Post by miskeen
Member Avatar for Ravenous Wolf

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:

@"databaseserver\c\remotefolder\remotedatabase.mdb"

Member Avatar for miskeen

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.