I am getting MS Access 2000 and/or 2003's standard record locking message ( WRITE CONFLICT record is being edited by another user. save changes, copy changes to clipboard, drop changes). This is occurring when the only user is me. The database is split, so the data is on a networked location.
The frontend and backend databases Tools|Options|Advanced are set as follows:
Default Open Mode: Shared
Default Record Locking: No locks
Open Databases using record-level locking: not checked
The launching form has the following properties:
Form DEDDEDf):
Allow Edits: No
Allow Deletions: No
Allow Additions: No
Allow Data Entry: No
Record locks: No Locks
All text field controls are Enabled=No, Locked = No. There are button controls which are enabled. There are 2 subforms, each of which is enabled = No, locked = No.
Obviously, this form is intended to display data but not allow it to be edited. DEDDEDf holds a button control "Edit Donor Detail" which opens form Donor Summary from which data can be edited. DEDDEDf remains open in the background while the user edits data on Donor Summary. When I click the Exit button from Donor Summary is when the error occurs. The code behind the exit button performs some data validation then docmd.close.
I thought I had a pretty straightforward database here in terms of locking (that is NONE). There are only 2 users for this database and overlap is rare, so I didn't feel like I needed locking but it looks like I'm getting it anyway -- and I don't want it.
Any clues regarding where this record is getting locked?
Thanks for any and all,
Erin
Start Free Trial
