Could not update; Currently locked! with record level locking

[synthkid]

Hello.

I have a form that uses a query with 3 linked tables; leftmost (main)
and 2 linked tables.\The tables are linked in the backend database
using a one-to-one relationship with these settings

Enforce referential integ.
Cascade Update
Cascade Delete

The backend and front end apps specifcy record level locking on all
settings. I trying to get away with not setting any DAO properties in
the form.

Using the form, I can succesfully insert new records by valuing the
left table key field and the 2 key fields in the 2 related tables

I can also delete records OK. The record in the main and 2 related
tables are erased.

But when I go to update the actual key fields because the underlying
components for the key field changed I run into trouble. I change the
main table key field on the form and the 2 related tables key fields
(which I don't know if I should be doing) and I get the following when
I try to save;

"Could not update; Currently lock"

I've tried just about everything. no one else is using the backend
database. it is all on one machine

Thanks for any help with this.

 

[synthkid]

I neglected to add the Err.Number is 2046 which indicates the record is
locked by another user. But there is only one user testing this
application.

Thank you