By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,639 Members | 2,340 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,639 IT Pros & Developers. It's quick & easy.

MS Access 2000 Error Message 3051

P: 2
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
Share this Question
Share on Google+
3 Replies


NeoPa
Expert Mod 15k+
P: 31,495
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

P: 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 15k+
P: 31,495
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.