473,320 Members | 1,699 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,320 software developers and data experts.

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
3 2155
NeoPa
32,556 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
32,556 Expert Mod 16PB
Oh, good for you. Glad it's resolved.

Welcome to Bytes!
Sep 23 '08 #4

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

Similar topics

1
by: ErickR | last post by:
We are experiencing a problem with Sql Server 2000 linking to an Access 97 file. We have two machines that link to this .mdb file, and we recently upgraded one to newer hardware, SP3a, MDAC 2.8,...
1
by: RichGolebiowski | last post by:
I have a class library (clsTestLib) that was created in VB.Net that I would like to use in Access 2000. I created a typelib for the class using regasm.exe. I am able to refernce (add a reference)...
8
by: Mike Thomas | last post by:
I have two clients now who want to have an Access 2000 & 2002 application running on NT Server 2000 do some file updating at night when nobody is in the office. I have used Windows scheduler to...
3
by: Michael | last post by:
I am using MS Access 2000 on an Windows XP machine and am trying to use the Upsizing Tool in Access 2000 to upsize an Access 2000 database to use with Microsoft SQL Server 7.0. My MS Access...
6
by: Peter Frost | last post by:
Please help I don't know if this is possible but what I would really like to do is to use On Error Goto to capture the code that is being executed when an error occurs. Any help would be much...
7
by: Ottar | last post by:
I've made a program sorting incomming mail in public folder. The function runs every minute by using the form.timer event. In Access XP it runs for weeks, no problem. Access 2003 runs the same...
0
by: Aaron | last post by:
Hi Guys, I have a dbase installed on a network where the clints have linked tables to the database on the server. I found that i had to make some minor changes to the tables on the server...
4
by: Aliza Klein | last post by:
Apologies in advance as I am SURE this has been asked 100 times - but I haven't got a simple answer: I have MS Office XP Developer and have created an installation package (with the runtime) for...
4
by: greg | last post by:
Hi, I have a read only access file with a linked table that connects to a sybase database. So I can still add data to the table even though its read only since the table is really in sybase. ...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.