Strange record locking issue

[Dorian]

A user reported he could not enter data in a control for one particular record.
I checked this and it was so.
I copied the front and back ends to my local drive and rechecked and it
worked ok.
I checked the code and nothing locked or disabled this control.
I had all users log off and did a compact/repair.
The problem 'went away'.
Any clues as to what caused it?
It seems somehow that one record got 'locked'. The user having the problem
did create the record a few minutes earlier.
-- Dorian
"Give someone a fish and they eat for a day; teach someone to fish and they
eat for a lifetime".

 

[Armen Stein]

A user reported he could not enter data in a control for one particular record.
I checked this and it was so.
I copied the front and back ends to my local drive and rechecked and it
worked ok.
I checked the code and nothing locked or disabled this control.
I had all users log off and did a compact/repair.
The problem 'went away'.
Any clues as to what caused it?
It seems somehow that one record got 'locked'. The user having the problem
did create the record a few minutes earlier.
-- Dorian
"Give someone a fish and they eat for a day; teach someone to fish and they
eat for a lifetime".

Hi Dorian,

Could any other users (or the same user in another instance) have been
using the same back-end database? Are the forms set to pessimistic
locking (e.g. "Locked Record")? That could possibly cause behavior
similar to what you describe.

Armen Stein
Microsoft Access MVP
www.JStreetTech.com