> I have a table in an access database and when you click a button, it
copies
> the table into another database. All works fine apart from it not
writing
> over the table with the same name already there. Iy just adds a
number to
> the end of the table name and adds it to the tables in the backup
db. I want
> it to write over the top of the backup table. I tried to delete the
table so
> that it would do pretty much the same thing but it told me that it
was being
> used. In the macro I built to copy the table, I first specify to
close the
> table.

> Any ideas on how to get around this one???

> Thanks in advance

> Murray Chapman