By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
460,036 Members | 960 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 460,036 IT Pros & Developers. It's quick & easy.

Bug: locked by another user?

P: n/a
Hi

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
Nov 13 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a
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

Nov 13 '05 #2

P: n/a
Thanks.

It seems to have stopped happening for some reason, but I've made a copy of
your post in case it comes back.
Nov 13 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.