
Backing up tables to external access db's
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