How can I clear all the data from an access database, but maintai.

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

How can I clear all the data out of an existing database, but maintain the
database structure, forms, reports, etc.?
 
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.
 
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.?
 
Hi Tim,

On a copy of your database run a delete query on each table you want to
clear.

HTH
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Clean all "data" from a database 3
Remote Database and Office Database 15
Access Access Report Works on One Machine but not Another 3
Access Clear all records in access 2
Copying Database Structure 2
ACCESS 2003 SP3: "The database has been placed in a state by user 4
How can I copy an entire MS Access database? 1
Open Existing Database dialog box at startup 3

Back
Top