I have a form linked to a table (the name is [Manual Temp
File]) in which the user can add more records. There is a
command button on this form linked to a macro that will
append the contents of this table to another table. After
the append, I then try to delete the [Manual Temp File]
table and replace it with a blank copy of the same table
structure.

Before doing deleting the table, I make sure that teh
macro closes all the forms and queries that might have
been used this table.

Unfortunately, Access selects the table but it won't
delete it and a window pos up. The window says: "The
database could not lock Table Manual Temp File because it
is already in use by another person or process"

Can anybody tell me what could be going and what I can do.
Thanks.

Pele

The

Instead of deleting the table why not delete the records
with a delete query?

Chris

>-----Original Message-----
>I have a form linked to a table (the name is [Manual Temp
>File]) in which the user can add more records. There is a
>command button on this form linked to a macro that will
>append the contents of this table to another table. After
>the append, I then try to delete the [Manual Temp File]
>table and replace it with a blank copy of the same table
>structure.
>
>Before doing deleting the table, I make sure that teh
>macro closes all the forms and queries that might have
>been used this table.
>
>Unfortunately, Access selects the table but it won't
>delete it and a window pos up. The window says: "The
>database could not lock Table Manual Temp File because it
>is already in use by another person or process"
>
>Can anybody tell me what could be going and what I can do.
>Thanks.
>
>Pele
>
>The
>.
>

Chris,

Thank you very much. I didn't even think of that; it was a
better solution and it worked.

Pele


>-----Original Message-----
>Instead of deleting the table why not delete the records
>with a delete query?
>
>Chris
>
>>-----Original Message-----
>>I have a form linked to a table (the name is [Manual
Temp
>>File]) in which the user can add more records. There is
a
>>command button on this form linked to a macro that will
>>append the contents of this table to another table.
After
>>the append, I then try to delete the [Manual Temp File]
>>table and replace it with a blank copy of the same table
>>structure.
>>
>>Before doing deleting the table, I make sure that teh
>>macro closes all the forms and queries that might have
>>been used this table.
>>
>>Unfortunately, Access selects the table but it won't
>>delete it and a window pos up. The window says: "The
>>database could not lock Table Manual Temp File because
it
>>is already in use by another person or process"
>>
>>Can anybody tell me what could be going and what I can
do.
>>Thanks.
>>
>>Pele
>>
>>The
>>.
>>
>.
>