[AccessD] Table locked

MartyConnelly martyconnelly at shaw.ca
Thu Aug 4 17:53:06 CDT 2005


Check If the mdb file isn't set to readonly or the associated ldb file 
isn't still open (This can be safely
deleted if all users are out of the database) otherwise
you might import all the Access objects to a new clean database to avoid 
any corruption.
This corruption can be common on Access 2000 mdb's without SP-3

Corrupt Microsoft Access MDBs FAQ
http://www.granite.ab.ca/access/corruptmdbs.htm

Kaup, Chester wrote:

>I have a database on my local C drive. When it opens it runs an autoexec
>macro to run a query to make a table. I get a message that the table can
>not be opened exclusively. How can this be and how do I determine what
>has the table open? I have tried compacting and repairing and opening
>the database exclusively with no success. Thanks.
>
> 
>
>Chester Kaup
>
>Engineering Technician
>
>Kinder Morgan CO2 Company, LLP
>
>Office (432) 688-3797
>
> 
>
>No trees were killed in the sending of this message. However a large
>number of electrons were terribly inconvenienced.
>
>FAX (432) 688-3799
>
> 
>
>  
>

-- 
Marty Connelly
Victoria, B.C.
Canada






More information about the AccessD mailing list