unable to lock table, split database

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

Guest

I have a split database that I have mounted the back end onto a network drive
though the server. The front end, I have e-mailed to everyone individually
and have had them save it on their personal drives. I have checked all the
sharing options, and have selected Shared, No Locks, and have deselected
"open db with record level locking." At this point I am still getting the
"cannot lock table, in use by..." message. I have changed my coding from
Macro to VB, and everything else I can think of. Is there anything anyone can
recommend.
 
What precisely is the message you are receiving?
At what point do you get this message? (e.g. when opening the database,
first bound form, ???)

It could be anything form a security (mdw) file that is the same name as
your mdb and in the same folder, to connecting through a read-only path on
the network, to a spurious ldb left over after a crash, to a corrupted
database, or ...
 
I am getting the message..."Could not lock table 'Table Name'; currently in
use by user 'Admin' on 'Computer Name.' I get this message when I try to open
the main form from the switchboard I created. Not actually using the
switchboard, I created a form with VB code for more extensive use. The be
file is the only item in the folder, I checked the server and it is not read
only. I'm just lost on this one.
 
Suggestions:

1. Close Access, and make sure noone else is using the database eitther.
Check both the back end folder and the front end folder.
If you see a small file with the same name as your mdb but with an LDB
extension, delete this file. The LDB contains locking information. Access
normally deletes this file when it closes, but it may be left there is your
computer or the software crashes, and it can contain spurious locking
information.

2. Open the back end, and uncheck the boxes under:
Tools | Options | General | Name AutoCorrect
Explanation of why:
http://allenbrowne.com/bug-03.html
Compact the database to get rid of this junk:
Tools | Database Utilities | Compact

3. Repeat step 2 for the front end.

4. Close Access. Make a backup copy of the front end. Decompile 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\MyFrontEnd.mdb"
The compact again.

5. Temporarily disable any startup code you have in your database, e.g.
rename any AutoExec macro, and clear the Startup Form box under:
Tools | Startup.
Then restart the database, and see if you can open this table directly from
the Database window. If you can see if you can open the problem form
directly from the database window.

If you are still stuck reports the results from the final step.
 
Back
Top