Creating new database from old structure?

  • Thread starter Thread starter courtney
  • Start date Start date
C

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?
 
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
 
I am sorry, I failed to mention, that all of the tables
are linked to a back-end database.
 
When you use the import feature, at some point there is an 'Options' button,
where you can choose 'Structure' rather than 'Structure and Data'
 
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.
 
Back
Top