Security-Same Data Same Time

J

Jani

Help me please! Somehow a table linked to SQL within an Access database has
gotten 'secured.' I can not add nor delete from the table. The message that
is displayed when I try to do so is: The Microsoft Jet database engine
stopped the process because you and anther user are attempting to change the
same data at the same time. There is no one else using the database nor the
table so I am quite confused as to what to do. I have shut down my laptop
thinking it would clear but no such luck. Thanks much in advance for your
assistance! Jani
 
L

Lynn Trapp

Jani,
It's quite likely that there is a "ghost" .ldb file sitting out there that
is preventing you from updating the table. Check to see if there is a .ldb
file in the same folder that the .mdb file resides in and delete it.
 
Top