Create a new empty data base exactly copied from an existing data base

[AllanW]

I have been constructing a data base and through many tests have meaningless data in the forms and tables. I would like to start useing the data base with the intended information without the test rubbish and start forms with line item 1 etcetra. Can I duplicate a data base without including the old data?

[JoeM]

You can copy each table's structure without the data, or you can simply delete all the data in the tables.

[AllanW]

Thanks JoeM, I had hoped for a way to "save as empty data base"

[JoeM]

I do not know of any such option, at least not without creating some VBA code to copy all the table objects with data, or delete all the existing data.
Here is a link to VBA code to delete all the data out of existing tables in one step: http://stackoverflow.com/questions/6...tables-at-once

[ranman256]

Build a macro that will export the tables you want STRUCTURE ONLY, (no data) to another db.
TransferDatabase command