Understanding Jet record locking

[lotstolern]

I'm trying to understand the order of writing new records and why I'm triggering a "The Microsoft Jet database engine stopped the process because you and another user are attempting to change the same data at the same time." on a single user Access 2k db.

The sequence is
1. Create a new Consumer record. tblCons
2. Then a new Consumer Address record. tblConsAddr
3. Create a new Org record. tblOrg linked to tblCons through a join table, tblConsOrg
4. Then create a new Org Address record. tblOrgAddr
5. Return to the Consumer record and check an item in a check box
6. Then create a new Consumer Phone record. tblConsPhone
7. Return to current Consumer record.
Now repeat the process. This time when you return to current consumer record after adding the phone record you will receive the error.

This error does not happen if you do not enter a new Org Address record. I've been told the error is related to the buffer Access maintains when adding records. So something about adding a new OrgAddr is causing triggering an attempt to access a record that is unavailable because it is in the buffer and not yet committed.

Does this make any sense? Is there enough info for you to take an educated guess? I need to understand where I'm causing the problem. Any guidance appreciated.

E

 

[lotstolern]

After experimenting further I've discovered that if I alter the order by creating the new organization last I eliminate the error. Does make this simpler to understand?

E