473,320 Members | 1,978 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.

Preventing locking

Hi

This is my first post so I hope I can make my problem understandable (?)

I have an Access database which is used by approx 8-10 users at a time. On a intermittant basis, users are getting a message "Could not update; currently locked by user 'Admin' on machine '[machine no]'". The 'offending machine is always the same one. This user is not opening the database exclusively or in any other obvious way to cause the problem. I have looked at the Access settings and cannot see any obvious reason for this to occur. Our organisation uses a modified version of Windows XP.

Any ideas of what may be the problem and suggestions to fix it would be gratefully received.

Thanks

David
Aug 1 '07 #1
10 1507
dima69
181 Expert 100+
Hi

This is my first post so I hope I can make my problem understandable (?)

I have an Access database which is used by approx 8-10 users at a time. On a intermittant basis, users are getting a message "Could not update; currently locked by user 'Admin' on machine '[machine no]'". The 'offending machine is always the same one. This user is not opening the database exclusively or in any other obvious way to cause the problem. I have looked at the Access settings and cannot see any obvious reason for this to occur. Our organisation uses a modified version of Windows XP.

Any ideas of what may be the problem and suggestions to fix it would be gratefully received.

Thanks

David
Looks like your question is quite a complicated one. Maybe some more details will help, like:
Are you using Front End - Back End DB configuration ?
What access version are you running ?
What network protocol is there ?
What kind of record locking is there ?
What is different about the 'offending' machine ?
Does it happen even if the database is not opened on that machine ?
Aug 1 '07 #2
I have the similar problem, I am running Acces 2003 and Windows XP. This problem is causeing the Database not to be used. My egineer opens it in the morning, and leaves it open all day. Most of the time he is just viewing it, but he does edit the records, and adds new ones. Every now and then, nobody else can enter into the database, because it is locked out by him. any ideas?

Brian
Oct 23 '07 #3
Curben
47
I have the similar problem, I am running Acces 2003 and Windows XP. This problem is causeing the Database not to be used. My egineer opens it in the morning, and leaves it open all day. Most of the time he is just viewing it, but he does edit the records, and adds new ones. Every now and then, nobody else can enter into the database, because it is locked out by him. any ideas?

Brian
Brian, in your case I get the feeling you do not have a secure database. If you create a secure database then you should be able to have multiple users access the database. My question is this, Does the engineeer need it open all day, or is he forgetting about it. I have worked with some forgetful users who open a DB and leave it open so we scheduled a program close.
Oct 23 '07 #4
He seems to want it open all day, although he might forget about it. I don't think he would mind if it closed after an amount of time, where he is not using it.
Oct 23 '07 #5
Curben
47
He seems to want it open all day, although he might forget about it. I don't think he would mind if it closed after an amount of time, where he is not using it.
If he needs it open all day the addings security may be your best bet. by being logged in as seperate users multiple people should be able to access
Oct 23 '07 #6
Can you tell me exactlly how I would do this?
Oct 23 '07 #7
Curben
47
Can you tell me exactlly how I would do this?
http://support.microsoft.com/default...t%2Fsecfaq.asp

There should be an access security wizard to walk you through most of the steps. In 2003 It's in : Tools > Security
Oct 23 '07 #8
I went through the wizard, and it just does the security to my computer. Now I have to enter a password, whenever I open a database. This is with all of the databases I have access to. How can I remove this, and be able to do what I want?
Oct 23 '07 #9
Never mind I got rid of it. But I still will have the locking problem.
Oct 23 '07 #10
Curben
47
Never mind I got rid of it. But I still will have the locking problem.
Did you have the locking problem while security was enabled?

Yes security will require the use of Usernames and Passwords, but as far as I know it is the only way to allow multiple people to access the DB Simultaneously.

Once it is enabled, it is possible to create a shortcut that will open the Database and login for you. In that same shortcut you can also link to the workgroup file used so you will not have to change the default

Use this as an Example Shortcut Target
Expand|Select|Wrap|Line Numbers
  1. "C:\Program Files\Microsoft Office\OFFICE11\MSACCESS.EXE" 
  2. "\\127.0.0.1\Project\Project.mdb" 
  3. /wrkgrp "\\127.0.0.1\Project\ProjectFiles\Security\Project.mdw"
  4. /User "MyName" 
  5. /Pwd "MyPa55word"
Link to the Access Program
Then the file
Then the workgroup
Followed by username and password
Oct 23 '07 #11

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

Similar topics

5
by: Fred | last post by:
Hi out there, I have problems finding a way to warn a user that another user intends soon to update the same specific row. Let me explain. User 1 get to a JSP "update customer record" page....
16
by: Nid | last post by:
How do I do row-level locking on SQL Server? Thanks, Nid
18
by: Elroyskimms | last post by:
I have a table using an identity column as its Primary Key and two columns (table reduced for simplicity) EmployeeNumber and ArrivalTime. CREATE TABLE ( IDENTITY (1, 1) NOT NULL , (10)...
11
by: EoRaptor | last post by:
I`m exporting data from many Lotus Notes databases to a DB2 database using LotusScript. The LotusScript agents commit after EACH update/insert. Nevertheless, I keep getting transaction rollbacks on...
1
by: ano1optimist | last post by:
We've got users sharing a database where the front end apps reside on the local PC while the backend app is on the network. We have repeated problems where certain users lock the database causing...
10
by: McFly Racing | last post by:
Thread Locking In Static Methods I have the need for a Log Manger class that has static methods. Normally I would use the lock statement or a Monitor statement both of which take a...
0
by: xpding | last post by:
Hello, I have a class MyEmbededList contains a generic dictionary, the value field is actually the MyEmbededList type as well. There is another class need to access and manipulate a list of...
8
by: mark_aok | last post by:
Hi all, I have a split database. Both the forms, and the tables are stored on a shared network drive (this is Access 2003). The users use the forms, and the tables on the network drive, there...
0
by: Cindy Huyser | last post by:
I have an Access 2000 database behind a threaded Java application that that can have have concurrent access to the same table (but not the same record). The database is set up for shared access...
0
by: moltendorf | last post by:
I've been trying to find a suitable method for preventing race conditions in my own code. Currently I'm using a file and the flock function to prevent code in other threads from executing at the...
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: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
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.