Macro to delete Table - table lock message by Access

  • Thread starter Thread starter pele
  • Start date Start date
P

pele

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
 
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
.
Click to expand...
.
Click to expand...
 
Back
Top