[AccessD] Table locked

Problem solved. I had it set up to open a form that referenced a table
that a query was trying to update. Changed the sequence of events and
all is well

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of MartyConnelly
Sent: Thursday, August 04, 2005 5:53 PM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] Table locked

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



-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com