Using same structure.

  • Thread starter Thread starter Cheese
  • Start date Start date
C

Cheese

Is there a fast way to recreate the structure of a database without the data?
I would like to use the design but not the data...

Thanks!
Cheese
 
Cheese,
Make a copy of each table. Right click a table, choose copy, choose
structure only.
Access will make a copy of the table with all the structure but no data.
The next problem is naming the tables with names that are exactly the same
as the ones you copied so they will work with the queries, forms, reports
and modules.
One possibility is to rename the original tables by adding a prefix to each
name such as z, then you can rename your new tables to the same names that
the original tables used.

Jeanette Cunningham
 
Jeanette,

Thank you, I was aware of this capability but was hopeful that there was
something abit simpler.
 
Jeanette described how.

Now, ?why?!

If you are attempting to solve some problem using a relational database
(e.g., Access), and want multiple tables with identical structure, you
probably need to go back to the drawing board!

For example, if you used a table to store data from 2006, you might think
you want to make a copy so you can store the same kind of data for 2007 (and
again, for 2008, and again, for ...). As they say in the game shows,
BZZZZZZ!

Use a single table, and add a field for the year. Better yet, in most
instances, add a field for a date/time value. With a design like this, you
want to start data for a new year, just put the data in with the date in the
new year!

If you'll describe a bit more specifically why you want to do this, the
newsgroup readers may be able to offer more specific suggestions...

Good luck!

Regards

Jeff Boyce
Microsoft Office/Access MVP
 
There is a way to do this all in one go.
Create a new blank database. Import the tables from the other database - in
the import wizard there is an option to import tables as structure only.

Jeanette Cunningham
 
Is there a fast way to recreate the structure of a database without the data?
I would like to use the design but not the data...

Thanks!
Cheese
Click to expand...

With the caveats in Jeff's post in mind, if you want to clone the structure of
A.MDB in a new B.MDB, create B.MDB; and use File... Get External Data...
Import to import everything. There's an option when you import the tables to
import the structure only, or structure and data.

John W. Vinson [MVP]
 
Back
Top