[RESOLVED] Access Database Shared on the server

[ryanbesitulo]

Hello experts,


I have no idea on how to connect access database shared on the server in vb6.0 application,..I just want, Map it and browse it in my program to connect,and 3 users can access it.
Can anyone help in my problem.


Thank You,

[dee-u]

You just have to specify the path where the database is located, something like this.

"Provider=Microsoft.Jet.OLEDB.4.0;Persist Security Info=False;Data Source=\\computer1\SharedFolder\db1.Mdb"

computer1 is the name of the computer, SharedFolder is the shared folder where d1.mdb is located.

[GaryMazzone]

Remember the users need: update,write and delete premissions on the remote folder.

[ryanbesitulo]

Remember the users need: update,write and delete premissions on the remote folder.

Thanks for reply,


But I am using DAO,


Thanks,

[ryanbesitulo]

You just have to specify the path where the database is located, something like this.

"Provider=Microsoft.Jet.OLEDB.4.0;Persist Security Info=False;Data Source=\\computer1\SharedFolder\db1.Mdb"

computer1 is the name of the computer, SharedFolder is the shared folder where d1.mdb is located.

Thanks for reply,

It helps me...Thanks a lot both of you

[GaryMazzone]

DAO or not when using MS Access the ldb file needs to be written to the folder that the database resides in. To perform this write you need write permission on the folder, once created every one else joining while open need to be able to modify the file. When the last person exits the database the ldb file needs to be deleted so delete permission is also needed.