Replica

[Guest]

I am new to Access. I have a database from last school year of students. I
want to start out this year with a 'new' blank database for this year's
students. How do I do it? I want the same functionality in the 'new' blank
database as the 'old' one. Thanks....

 

[Guest]

Usually what I do is make a copy of the database (i.e. copy "school2006.mdb"
to "school2007.mdb"). Then go into the "new" database and delete all the
records. Might be crude, but it works. I do it every year with a databse I
made for event scoring.

 

[John W. Vinson]

I am new to Access. I have a database from last school year of students. I
want to start out this year with a 'new' blank database for this year's
students. How do I do it? I want the same functionality in the 'new' blank
database as the 'old' one. Thanks....

Alan's suggestion is one way; it may be a bit cleaner to open Access without
opening ANY database. Create a new .mdb file, and then use File... Get
External Data... Import to import everything (tables, queries, forms, etc.)
from your old database. When you import Tables there is an option to import
the design only; if you choose this you'll get a set of empty tables.


John W. Vinson [MVP]