T
Tim
How can I clear all the data out of an existing database, but maintain the
database structure, forms, reports, etc.?
database structure, forms, reports, etc.?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
K
Ken Snell [MVP]
Create a new database. Import all the objects from the old database to the
new one -- but before you click the OK button, click the Options button at
bottom right of that screen where you select the objects. You'll see a
checkbox for Defintiions Only -- check that box and that will leave your
data behind but bring over the tables and their structures.
new one -- but before you click the OK button, click the Options button at
bottom right of that screen where you select the objects. You'll see a
checkbox for Defintiions Only -- check that box and that will leave your
data behind but bring over the tables and their structures.
T
Todd Shillam
1. Backup! Copy the file and save elsewhere or with a different name.
2. Ok...now that we have that covered. You can just open the tables and delete the records in all the tables; however, if there is referential integrity in place, you will have to delete records in related tables first.
Best regards,
Todd Shillam
How can I clear all the data out of an existing database, but maintain the
database structure, forms, reports, etc.?
2. Ok...now that we have that covered. You can just open the tables and delete the records in all the tables; however, if there is referential integrity in place, you will have to delete records in related tables first.
Best regards,
Todd Shillam
How can I clear all the data out of an existing database, but maintain the
database structure, forms, reports, etc.?
L
Larry Daugherty
Hi Tim,
On a copy of your database run a delete query on each table you want to
clear.
HTH
On a copy of your database run a delete query on each table you want to
clear.
HTH