How to begin a new database using the structure of an old one?

S

Sally

I have already created an access database with many tables, and the whole
thing is structured the way I want it. I now want to create a new one to
which I shall add new information of a similar kind. I want all the tables to
be empty, but to be structured the same way as the old one, and I'd like them
all to begin automatic numbering at zero (otherwise I could just copy the
database, change the name, delete the existing information, and start adding
new information.
 
F

fredg

I have already created an access database with many tables, and the whole
thing is structured the way I want it. I now want to create a new one to
which I shall add new information of a similar kind. I want all the tables to
be empty, but to be structured the same way as the old one, and I'd like them
all to begin automatic numbering at zero (otherwise I could just copy the
database, change the name, delete the existing information, and start adding
new information.
Click to expand...

You can...

1) Delete all the data in the tables (not the tables themselves) of
your existing database.
Then Tools + Database Utilities + Compact.
All your autonumbers will be reset.

Or..

2) Create a new Database.
Click on File + Get External data + Import
Navigate to the database you want to use as template.
Click on the Tables tab.
Select all the tables.
Click on Options.
Place a check mark in the Definition Only check box.
Check the Relationship box also.
If you have custom Menus or Toolbars, check that also.
Click on all the other tabs and select all the reports, forms,
queries, modules, etc.
Click OK.

Your new database will be ready for data.
 
A

Al Camp

Sally,
Do that...
otherwise I could just copy the database, change the name,
Click to expand...
delete the existing information, and start adding new information.
When all your new tables are empty, Compact the new database,
and start adding new records. Those autonumbers should all be reset to 0.
 
Top