Duplicating a Database Design

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Jack M - 23 May 2005 04:57 GMT

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.

Reply to this Message

Ken Snell [MVP] - 23 May 2005 05:51 GMT

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.

Signature

Ken Snell
<MS ACCESS MVP>

> How can I duplicate the design of an existing database for a second
> similar
[quoted text clipped - 7 lines]
> 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.

Reply to this Message

Jack M - 27 May 2005 12:20 GMT

Thanks, Ken.

This was just what I was looking for.

Jack M

> Create a new, empty database. Import the tables *without data* from the old
> database into the new database.
[quoted text clipped - 19 lines]
> > 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.

Reply to this Message

DL - 23 May 2005 09:49 GMT

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.

> 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
[quoted text clipped - 4 lines]
> 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.

Reply to this Message