Security-Same Data Same Time

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Checking Two Conditions in a Macro 3
can't delete record if checkbox is false 1
linking to SQL Server db table 6
VBA Excel - Select a value from one cell in Excel to update a SQL table 1
Call stored procedure in SSMS from Access 2016 doesn't work. 0
Error 3197 1
you and another user are attempting to change the same data at the 2
Same record/Primary key in multiple tables 0

Back
Top