[AccessD] Could not update; currently locked

Nicholson, Karen cyx5 at cdc.gov
Thu Feb 24 06:15:40 CST 2005


Make sure that you do not have any fields in the SQL table defined as
bits - for some reason when trying to add a new record at times, Access
throws a locked message as a null value for a bit is not acceptable to
SQL.  I change my bits to ints and it goes away.

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Erwin Craps -
IT Helps
Sent: Thursday, February 24, 2005 3:24 AM
To: Access Developers discussion and problem solving
Subject: RE: [AccessD] Could not update; currently locked


I seen this to (but in A2K3), I wonder if this is not the result of the
Oportunistic locking issue in Windows server.
Does anynone know if this isssue is resolved on W2000 and W2003 server,
or does this Oportunistic locking still needs to be turned of for
Access?

Another posible cause in A2K3 is that you can set locking differently in
each form (which makes it hard to locate the problem). I'm not sure if
this functionality is also present in A2K2?
I'm not sure, but I believe when creating (or importing) new forms the
formlocking is not set to the same as in the database options...

Erwin
 

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of John W. Colby
Sent: Thursday, February 24, 2005 4:24 AM
To: 'Access Developers discussion and problem solving'
Subject: [AccessD] Could not update; currently locked

I have a database (Windows XP, AccessXP) where a child form (no code AT
ALL) gets the error message "Could not update; Currently locked" at the
instant that the user tries to select something in a combo.  The table
that the data is going in to is small, 5 IDs (FKs for other tables) a
date, a time and a memo which is actually a text field.  

The record selector does NOT display the locked symbol (circle with a
slash).  This database has a small number of users, perhaps 5 or 6, ALL
of them are working in this main / sub form.  It is a people table
(parent
form) with a "communication" subform which records all phone calls etc
to the people in the parent form.  This is SIMPLE, nothing much there.

When the lock occurs, ALL users end up locked.  Any given user has to
close the main form and re-open And they can continue onward with
whatever they were trying to do.

I have checked service packs (SP3).  All machines are set to "locked
record".  The BE is compacted / repaired regularly and doesn't seem to
help.

I am not there, and it is several hundred miles away so I am trying real
hard to not have to go there.

Has anyone seen something of this nature?  It looks like a PeopleComm
record is created by this specific combo selecting something, and at the
instant something is selected from the combo something locks up the
PeopleComm table.  It cannot be created on demand, but it happens
regularly (every 15 minutes to 1/2 hour).  This form is the main working
form for this group of people, it is where they work, all evening.  It
is a major frustration for them.  I cannot see anything causing this.
There is no memo field, no lock symbol, no id of which user is causing
the lock, no nothing to work with here.  To be honest it looks like an
Access bug to me but...

Help!!!

John W. Colby
www.ColbyConsulting.com 

Contribute your unused CPU cycles to a good cause:
http://folding.stanford.edu/


--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com
-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com



More information about the AccessD mailing list