how to give the database path in connection string

Resmy Ravi

Hi...
I have placed my databse in access in another system in the network(computer1\e\nbr\medimain.mdb).So in the connection string how can i give the path of the database.if the database is saved in the same system,it works..
Plz...help me....

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

paul daniel16y ago
Hi

If u r using ms access 97 then use adodc connection drag this from tool box then make a right click and do the connection then test ur connection if it is donn then go to ur module code and write there code as Set cn = New Connection
cn.ConnectionString = "provider=Microsoft.Jet.OLEDB.3.51;data source=" & App.Path & "\name of database.mdb;"
cn.Open
n if using 2003 then
Set cn = New Connection
cn.ConnectionString = "provider=Microsoft.Jet.OLEDB.4.0;data source=" & App.Path & "\name of database .mdb;"
cn.Open

Thanks,
Paul daniel
0
Lalit M16y ago
you will get connection string from this link'

http://www.webcheatsheet.com/asp/access_connection_strings.php

http://www.connectionstrings.com/access
0