Duplicating a Database Design

[Jack M]

How can I duplicate the design of an existing database for a second similar
database -- and still be able to start all over with record #1 instead of
starting the record numbers with the next number from the original database?

The database design I want to copy is an elaborate and large family database
I designed for my family reunion. The database I want to create would be
similar, but would be for my wife's family. I may also want to do one for
friends or else combine two or more databases into the same design.

 

[Ken Snell [MVP]]

Create a new, empty database. Import the tables *without data* from the old
database into the new database.

Do this by opening the new database and clicking
File | Get External Data ... | Import

Navigate to the old database and select it.

When the wizard window opens, click the "Options" button at bottom right.
Check the box for Tables: Definitions only.

Then import.

 

[DL]

You could perhaps add a field for the specific family, then relationship
fields in other tables to link them.
By querying on the specific family it would only return details specific to
them.
If you did'nt wish to create a duplicate db. that is.

 

[Jack M]

Thanks, Ken.

This was just what I was looking for.

Jack M