467,076 Members | 863 Online
Bytes | Developer Community
Ask Question

Home New Posts Topics Members FAQ

Post your question to a community of 467,076 developers. It's quick & easy.

MS Access 2000 Error Message 3051

I have a MS Access 2000 database running my wife's cross stitch business. We have it on two PCs both running XP, with one having a linked mde APP front end (PC 2) and one having the MDB back end and a linked MDE front end. The MDB back end is in a shared folder, however, on switching PC 2 on and signing into the database error message 3051 is displayed: "The Microsoft Jet database ebgine cannot open the file ... It is already open exculsively by another user, or you need permission to view its data".

The database is not opened in exclusive mode and default record locking is edited record.

To overcome this I have to right click on the folder the MDB is in, click on properties, click on sharing, then unclick Allow network users to change my files and unclick share this folder on the network and then click them both again and finally click OK and hey presto the database is accessible on PC 2, until the next reboot!

This happens whether PC1 is signed into the database or not. The MDB is presently in a sub-folder of all users shared documents and is also set as a shared folder, but it has also happens if it has been in any other folder on PC 1 (also shared).

Whilst I know how to manually resolve this, I would be very appreciative if anyone knows how to stop this from happening in the first place.
Sep 21 '08 #1
  • viewed: 1911
Share:
3 Replies
NeoPa
Expert Mod 16PB
This sounds like a problem related to how the network connections are set up rather than an Access problem per se.

Do you have anyone there who understands setting up of shares and permissions etc?
Sep 22 '08 #2
This sounds like a problem related to how the network connections are set up rather than an Access problem per se.

Do you have anyone there who understands setting up of shares and permissions etc?
Hi, thanks for the reply. However, Access 97 same two computers, same database, same folders = no problem at all!!!
Sep 23 '08 #3
NeoPa
Expert Mod 16PB
Oh, good for you. Glad it's resolved.

Welcome to Bytes!
Sep 23 '08 #4

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

1 post views Thread by RichGolebiowski | last post: by
8 posts views Thread by Mike Thomas | last post: by
6 posts views Thread by Peter Frost | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.