Internal buffer lock

K

Keith

I'm getting an error message that is restricting me from importing data into
my own database. It states that another user locked the database but I'm the
only one using it. I've tried to close out and repair the database but then
it states the same thing.

Thanks in advance as always!
 
A

Allen Browne

Close the database.
Check there is no ldb file in the folder where the database lives.
The ldb contains locking info, and it can leave spurious info there if you
have a crash and Access does not get to clean up after itself.

If that does not solve the problem, and you are certain that no other
forms/reports/queries/tables are open and the no code is running, then the
symptom may indicate a corruption. Try these steps:

1. Uncheck the boxes under:
Tools | Options | General | Name AutoCorrect
Explanation:
http://members.iinet.net.au/~allenbrowne/bug-03.html

2. Decompile a copy of the database by entering something like this at the
command prompt while Access is not running. It is all one line, and include
the quotes:
"c:\Program Files\Microsoft office\office\msaccess.exe" /decompile
"c:\MyPath\MyDatabase.mdb"

3. Compact the database.

If that still fails to fix it, try the steps for the first symptom in:
Recovering from Corruption
at:
http://members.iinet.net.au/~allenbrowne/ser-47.html
so that Access recreates the database for you.
 
Top