[AccessD] Record locking bug

John, probably of no help, but I occasionally run into a nasty locking error
that's cleared only by closing down Access, and rebooting. Somehow, the
system seems another instance of the database running, when there isn't and
I can't do anything until I delete that "phantom" instance. I've no idea
what causes it. 

I didn't read the entire thread, so if this is way off, just ignore it. 

Susan H. 


Hmmm... I am updating a FK field that of course has an index.  I just
removed the index on this field, saved the tables, and tried again, still
getting the locking of surrounding records.