new database with duplicate structure

[JR Hester]

Sorry for reposting but has been a couple of weeks!! Thanks to Stockwell43
and Fredq for their suggestions from that post.

I used the import data from external source and did indeed get a database
with all empty tables. Unfortuantely this also emptied my switchboards as
well. Can anyone offer a suggestion other than executing delete queries for
each table that will EXACTLY duplicate teh entrire struicture of teh existing
database, yet empty the data tables??

ORIGINAL POST
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?

 

[Larry Daugherty]

Delete the empty Switchboard Items table from your new application.

Get External Data, import just that table from the earlier application
without choosing Structure Only.

HTH

 

[JR Hester]

Thank you. That was the step I was missing. All seems to be well in paradise
again.