A Microsoft Office (Excel, Word) forum. OfficeFrustration

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.

Go Back   Home » OfficeFrustration forum » Microsoft Access » Using Forms
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

"Could not update; currently locked"



 
 
Thread Tools Display Modes
  #1  
Old February 2nd, 2005, 02:50 PM
Paul
external usenet poster
 
Posts: n/a
Default "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  
Old February 2nd, 2005, 07:20 PM
JP
external usenet poster
 
Posts: n/a
Default

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  
Old February 3rd, 2005, 01:58 AM
Van T. Dinh
external usenet poster
 
Posts: n/a
Default

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  
Old April 16th, 2005, 06:18 AM
Mike77
external usenet poster
 
Posts: n/a
Default

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

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump

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


All times are GMT +1. The time now is 02:57 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.