If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
"Could not update; currently locked"
I have a multiuser database based around 2 main tables -
TblMaster and TblSub. They are linked with a one (TblMaster) to many (TblSub) relationship. Now, when someone enters data into the TblMaster fields and then tries to enter any data, either from a combo box or into a blank field, into the subform the database freezes and about 10 seconds later an error dialogue box pops up saying "Could not update; currently locked". Can anyone shed any light on what is causing this and how to rectifiy it? Thanks, |
#2
|
|||
|
|||
The first question is how you have your database structure. There are two
common structures: 1. A single MDB out on a network drive that everybody uses. This is a REAL bad idea because a single instance of an MDB uses all sorts of internal tables that are not necessarily sharable. Trying to have two or more people use the same executable will often give this error. 2. Two MDBs -- one that contains only the data tables and resides on the network drive (which I'll refer to as the data database). The second (which I'll refer to as the program database) that contains only the programs, queries, modules, macros, and reports as well as links to the data tables on the network drive. Each user would have his/her own copy of the program database running on his/her own local workstation. If you have the second structure, that's a good start. Then we have to worry about a few other things: 1. Type of locking in the forms and code. The default for Access forms is "optimistic locking". If you're using any other kind of locking, it could be that a users are stepping on each other because you have whole tables locked. 2. The number of users. Since Access is not client-server, it moves a hell of a lot of data across the network, and you can often get locking problems because the sheer volume overwhelms the speed of the network. How many users do you have and how big are the tables? More to the point, does this happen with only one user? 3. Is there a spurious lock file (.LDB) file floating around - especially on the server. Get ALL users out of your system (including yourself) and then use Windows Explorer to see if there is still a .ldb file on the network drive that contains your data database). If there is, delete it. This can happen sometimes when a program fails in testing. 4. This kind of problem could come about if your linking of the main and subform for tblMaster and tblSub. I can't tell from what you've written if there's a problem there. Your best bet might be to test it with a single user (you). If you get the problem, then it's probably your form/table design. If not, then it might be type of locking or number of users. It would be useful if you posted more about your tables and forms. "Paul" wrote in message ... I have a multiuser database based around 2 main tables - TblMaster and TblSub. They are linked with a one (TblMaster) to many (TblSub) relationship. Now, when someone enters data into the TblMaster fields and then tries to enter any data, either from a combo box or into a blank field, into the subform the database freezes and about 10 seconds later an error dialogue box pops up saying "Could not update; currently locked". Can anyone shed any light on what is causing this and how to rectifiy it? Thanks, |
#3
|
|||
|
|||
Are you using the Front-End / Back-End split system or just a single
database file? Check the RecordLocks Property of the Form and make sure it is not set to "All Records". -- HTH Van T. Dinh MVP (Access) "Paul" wrote in message ... I have a multiuser database based around 2 main tables - TblMaster and TblSub. They are linked with a one (TblMaster) to many (TblSub) relationship. Now, when someone enters data into the TblMaster fields and then tries to enter any data, either from a combo box or into a blank field, into the subform the database freezes and about 10 seconds later an error dialogue box pops up saying "Could not update; currently locked". Can anyone shed any light on what is causing this and how to rectifiy it? Thanks, |
#4
|
|||
|
|||
Hi!
I have the same problem with 2 of my dbs. I've tried anything just to see the error myself but i just can't reproduce it! It happens when two users are entering data at the same time. My databases are splited into backend/frontend. I have no record locking in any form, and the forms are in dataentry mode. The users are not and cannot be on the same record at the same time. The only thing i can see is that an autonumber is generated each time a record is created, and maybe when the users create a record at the same time, it gets me that message because the db cannot look for the next autonumber at the same time as another user ... Would that be possible? Any help would be greatly appreciated!! Mike |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Repost - Couldn't Update; Currently Locked. | Ndel40 | Running & Setting Up Queries | 2 | October 12th, 2004 07:01 PM |
Could not update; currently locked | Aaron | Running & Setting Up Queries | 1 | October 8th, 2004 04:57 PM |
Automatic Update | halchal9 | General Discussion | 1 | September 30th, 2004 09:54 PM |
Can't update TOC programmatically (but it worked yesterday) | Kathleen | Tables | 9 | July 12th, 2004 01:33 PM |
Why no update? Help! | Brian | New Users | 1 | May 6th, 2004 11:15 AM |