Delete all records

[JR Hester]

Access 2002 on WinXP

Have a database containing several tables containing scores to hundreds of
records. have modified a copy of the database for a new application, and used
the existing records for testing the new features. Am ready to turn database
over to new operator, but need to remove all existing records from all tables.

Is there an easy way to accomplish this short of executing a delete query on
each indivdual table? Hopefully something like that ancient aplication's ZAP
command. Basically I want to create a new database with all the existing
structure but none of the data. Is this possible? How?

Thank you

 

[Stockwell43]

Hi JR,

You can go in and manually delete the records and then do a compact and
repair OR
place a 1 after the title of each table and make a copy. Access will ask to
name the table (same as the copied one except don't add the 1 at the end) and
will give a couple of choices on creating the copy. Choose the one that is
Structure only. It is exactly like your original table except no data.

I not sure if that will but it's easier than making delete queries for all
your tables.

 

[fredg]

Access 2002 on WinXP

Have a database containing several tables containing scores to hundreds of
records. have modified a copy of the database for a new application, and used
the existing records for testing the new features. Am ready to turn database
over to new operator, but need to remove all existing records from all tables.

Is there an easy way to accomplish this short of executing a delete query on
each indivdual table? Hopefully something like that ancient aplication's ZAP
command. Basically I want to create a new database with all the existing
structure but none of the data. Is this possible? How?

Thank you

If there are lots of tables, it might be simpler to just create a new
blank database. Then, open this new database, and click on File + Get
External data + Import.
Navigate to the old database and click on Tables + Select All +
Options.
Place a check in Table Definition Only, and Relationships. Then click
on each of the other tabs, Query, Forms, etc., and select all. Click
OK.
Your new database now is ready for new data.