Access Error 3260.

[Guest]

I'm trying to run a query and I get this error after it starts running and
before anything is appended. I'm the only one using this database. Any
suggestions?




Could not update; currently locked by user <name> on machine <name>. (Error
3260)
You tried to update data that is located on a page that is currently locked.

Possible causes:

You tried to save a query being used by someone else. To save your query,
wait for the other user to finish or enter a different name, and then try the
operation again.
You tried to use the Edit method on a data page containing a record that is
already open or locked.

 

[Allen Browne]

There are a couple of causes for these concurrency errors.

A. Genuine concurrency issue
=======================
The first is that it really is a concurrency issue. Is there any other form,
query, or table that is also open at the same time, and is using the same
data? Is it possible that the other object is dirty? What kind of record
locking do you have under:
Tools | Options | Advanced | Default Record Locking
Optimistic locking (shown as "No Locks") is the default, and usually the
best.

If that is not the case, is there any code that used OpenRecordset() and
failed to Close correctly? Or is there report running in the background?

Close Access, and open the folder that contains the database. If there is a
small LDB file in the same folder, delete the LDB. This contains locking
information, and can contain spurious info after a crash (i.e. if Access
does not get to close normally.)

B. Corruption
==========
If none of the above apply, the message can indicate that the database is
corrupt. To repair it:

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

2. Compact the database:
Tools | Database Utilities | Compact.

3. 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"

4. Compact again.

5. Test. If the problem is still present, get Access to rebuild your
database by following the steps for the first symptom in this article:
http://members.iinet.net.au/~allenbrowne/ser-47.html