I get error 3051 when trying to connect VB with Access DB in a remote PC under W2k
Posted on 2003-11-06
I have a VB application which tries to connect to a MS Access 2000 database located in another PC within the network. When I try to do it with the remote PC under Windows 98, it connects correctly. The problem is that I can't connect to the DB when the remote PC is under Windows 2000 Professional. It shows me this error: << "Runtime Error 3051: The Microsoft Jet database cannot open the file '\\remotePC\SharedFolder\database.mdb'. It is already opened exclusively by another user, or you need permission to view its data" >>. I understand the error, but: The shared folder and the database have all the permissions for all the users, the remote PC is in the same LAN, the DB is not opened by another user and everything it's ok. But I still cannot connect to this remote DB located in a PC under W2K. Pls, anybody help me!.
Thanx a lot for any help and for reading this long question.