how to connect Ms access database from server to Client

[mastan]

i have done one client/server application using ms access/vb.
server-machine A-ex.mdb
client-machine b /c/d ..n

how to access ex.mdb to client machine.if i make setup programm then how to the client application detect the server database.
pl tell me the sourcecode immediatly.

 

[woyler]

Put the path of the .mdb in your connection string:

Dim cnConn as adodb.connection

set cnConn = createobject("adodb.connection&quot

cnconn.connectionstring = "Driver={Microsoft Access Driver (*.mdb)};" & _
"Dbq=\\YourServer\PathToDB;" & _
"Uid=Admin;Pwd=;"
cnconn.open