Discussion Locked

Locked Records

0 helpful
3 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

My access database seems to have a mind of its own- it was working fine, I added an update query to insert a new field on table and calculate a date.

When trying to edit data on the main form, the record acts locked, but when I click on link to subform and update it first, then go back to main form, it allows editing of data.
I have no problem putting in new data on main form.

I checked the user permission, properties on forms its all set at proper properties: locked(no), enabled(yes), allow edit,addition, deletion (yes), locked(no) etc. also the VB codes look fine

My thinking is the record lock is due to the calculating query, or maybe its the cycle - I'm not sure.
Please help

3 replies

by david

There are several factors at work here. The first obvious is place to check is in the OPTIONS what type of locking is being used. The second place, is the type of query and locking used.

Access Locking Controls the default record-locking behaviorin a multi-user environment.

Select No Locks
to not lock the record you're editing.

Select All Records
to lock all records in the form or datasheet (and underlying tables) you're editing for as long as you have it open.

Select Edited Record
to lock only the record you're editing.
There are many other things that can also
effect locking (such as paging). Hope this helps giving you a place to start looking

This discussion is closed to new replies.