H
Helena
Hi
I have a database with 22 tables from which I need to clear down all
of the records before importing fresh data. There is no criteria for
keeping / deleting specific records. I just want to do the equivalent
of opening the table, clicking in the top left and pressing delete.
I know that I can build a delete query to do this, but when I tried to
build a delete query showing more than one table I got a 3086 error.
Is there any way that I can do this other than building 22 different
delete queries and a macro to run them all?
Thanks
Helena
I have a database with 22 tables from which I need to clear down all
of the records before importing fresh data. There is no criteria for
keeping / deleting specific records. I just want to do the equivalent
of opening the table, clicking in the top left and pressing delete.
I know that I can build a delete query to do this, but when I tried to
build a delete query showing more than one table I got a 3086 error.
Is there any way that I can do this other than building 22 different
delete queries and a macro to run them all?
Thanks
Helena