Is there a way to copy the entire structure of a database without.

[Eduman]

I have created a database that has been used all year. Is there a way to
copy the entire structure without data for the following year? This is a
schoolbased database and I want to start over next year with a clean database.

 

[Eduman]

Nevermind. I used the above question and got nothing. While in the
discussion group, I typed copy database and saw the answer.

 

[Jeff Boyce]

?!None of the students will be in your school next year?! None of the same
classes/subjects/instructors/rooms/ ... or whatever else you are recording
in your database will be there next year?

There is rarely a strong business case for creating a second (and third, and
fourth, and ...) copy of the same database. Doing something like this makes
it very difficult to compare your data across years.

More common in a well-normalized database design is to include a field in
your table(s) for the year (or the date), and use that to filter what your
forms display to whatever year is "current".

Good luck

Jeff Boyce
<Access MVP>

 

[Eduman]

I appreciate the help. Your statement about a well-normalized database is
where I want to "start fresh". I built the database as I learned and the
relationships from table to table and within forms and reports is not "neat
enough for me" so I want to tear apart the tables and redo them under ideal
conditions knowing what I know now about relationships and foreign keys, etc.
As I do this, I don't want to mess with the current data so a blank database
will give me the flexibility to "play".