Creating new database from old structure?

[courtney]

I would like to create a new database using the structure
of an existing database, in which all fields needs to be
repopulated. I have tried using the import function but
it imports data and structure. I tried using the
cut/paste option but it is way too tedious to cut and
paste each individual object. What can I do?

 

[Harlan]

Courtney,
If all you want is a blank database just like your old one, make a copy of
the old one and then go to each table and delete the contents, do a compact
and away you go.

HTH
Harlan

 

[Guest]

I am sorry, I failed to mention, that all of the tables
are linked to a back-end database.

 

[Joan Wild]

When you use the import feature, at some point there is an 'Options' button,
where you can choose 'Structure' rather than 'Structure and Data'

 

[Alan fisher]

First create a new mdb file to be the new back-end. Exit
it, enter the existing backend and export all of the
tables. That is where you will have the option to choose
data and structure or just structure. Then make a copy of
the front-end and relink the tables to the new back-end.

Or you could just make a copy of the original back-end and
just delete all the data manually. Then recopy the front-
end and relink to it.