Empty copy of database

[Pat Garard]

G'Day All,

I have a back-end database that contains both client data tables and
supporting tables with lists (e.g. Languages, Income Ranges etc) for
combos on the Forms. All relationships are defined, including two
with cascading deletes.

I would like to take a "clean" copy of the database with client data
removed and all autonumber key fields reset (to 1 for the first record).

How may I achieve this?

 

[Allen Browne]

Create a new (blank) database.

Import all tables:
File | Get External

In the Import dialog, click the More/Options button (bottom right).
In the extended section, click the button form:
Structure Only

I suggest you disable the Name AutoCorrect options in the new database
before the import, to prevent the problems explained here:
http://allenbrowne.com/bug-03.html

 

[Pat Garard]

Thanks Allen!
Much Obliged!