Error: 3051

[Gonzo]

After I upgraded to version 2002 from 2000 I started
getting error 3051 when I try to link new tables or
refresh privious links of tables stored in a server.
This error is related to: I do not have access or do not
have rights to acces these tables. I log in as
administrator and there is no restriction to access
tables. Any Idea to fix this problem.

 

[Tom Wickerath]

When one runs this statement in the Immediate window:
?accesserror(3051)

the following is returned:
The Microsoft Jet database engine cannot open the file '|'. It is already opened exclusively by
another user, or you need permission to view its data.


Are you attempting to share a front-end .mdb file? If so, you really should consider loading a
copy on each user's PC. In the meantime, make sure that you are the only user who has the
database open if it is shared. Also, with Access closed, verify that you do not have a locking
database file (file extension is .ldb) present in the same folder. Locking database files are
typically 1 KB in size, and should be automatically deleted when the last user of a shared
database closes the database.

Tom
________________________________________


After I upgraded to version 2002 from 2000 I started
getting error 3051 when I try to link new tables or
refresh privious links of tables stored in a server.
This error is related to: I do not have access or do not
have rights to acces these tables. I log in as
administrator and there is no restriction to access
tables. Any Idea to fix this problem.