First thing to check is that there is no process that could be generating
the genuine error, e.g. two forms opened into a table that has a memo field
(even if both are not dirty), a recordset that was not properly closed in
code, an open form that has a record dirty at the time when you open a
recordset or execute an action query, of any of these kinds of thing that
are running in a 2nd instance of the database on your computer or the same
database opened on another user's computer.
If there are no genuine multi-user issues, and you are using optimistic
locking (recommended, i.e. "No Locks" under Tools | Options | Advanced |
Default Record Locking), then the message may be caused by a corruption. To
solve it, try this sequence:
1. Make sure the Name AutoCorrect boxes are unchecked under:
Tools | Options | General
Explanation of why:
http://members.iinet.net.au/~allenbrowne/bug-03.html
2. Compact the database:
Tools | Database Utilities | Compact
3. Close Access. Make a backup copy without overwriting any existing
backups.
4. 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"
5. Open the database, and compact again.
That should get you back into business.
--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users -
http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.
"Captain Nemo" <Ca*****@NoSpam.com> wrote in message
news:QT*******************@text.news.blueyonder.co .uk...
I seem to remember that in Access 2000 you can sometimes get a bogus error
message telling you that a certain table is 'locked by another user', when
there is no way that could be true.
Unfortunately, I can't remember what the workaround (if any) might be.
Can anyone help?
Thanks