Could not update;currently locked

[Kurt]

I am getting a 3218 "Could not update; currently locked"
error when I try to edit a record within the same
transaction or try to execute a SQL statement that
deletes the record in the same transaction. I am the only
one using the database.

Here's an example:

1. I pull up a record in my form using a combo box with
After Update event
2. I edit data in the form
3. I click a "delete" command button which uses SQL
statement to delete the record
4. I get "3218 Could not update; currently locked"

The problem might be related to this BUG

http://support.microsoft.com/default.aspx?scid=kb;en-
us;331594

.. . . but I don't understand how to implement any of the
suggested workarounds, which lack detail.

Any ideas? Thanks. - Kurt

 

[Michel Walsh]

Hi,


Try Me.Undo before trying to delete the record.


Hoping it may help,
Vanderghast, Access MVP

 

[Guest]

How elegant. Thanks.

Just curious: How exactly does Me.Undo fix this problem? I've searched
around but can't find anything. The problem I was having seemed so similar to
the MS bug but your simple solution suggests it wasn't that at all.

Kurt

 

[Michel Walsh]

Hi,


It seems that the record was not delete-able due to some lock related to
the edition in progress. Undoing the edition released the lock associated to
the record.



Vanderghast, Access MVP