create a new Access file using an existing file

[Guest]

We keep a yearly list of students and schools. I use 3 tables: one for the
schools, one for school reps and one for the students, related through a
"codes" table. Each year we need a new DB for the new students, but the
school and school reps information generally stays the same. Without
starting from scratch to create a new file, how can I use the existing DB
file to create a new file for the next year's student list? I use Access
2003.

 

[John Vinson]

We keep a yearly list of students and schools. I use 3 tables: one for the
schools, one for school reps and one for the students, related through a
"codes" table. Each year we need a new DB for the new students, but the
school and school reps information generally stays the same. Without
starting from scratch to create a new file, how can I use the existing DB
file to create a new file for the next year's student list? I use Access
2003.

Ummm... Why a new database for every year?

A school year value IS DATA. A student is a student, whether she's in
the class of 2004 or the class of 2009. Unless you're talking about
millions of students, I see NO point in creating a new database every
year! You can use Queries to select data for any particular year.

That said... you can create a new, empty database, and use File... Get
External Data... Import. The import dialog gives you a choice of
importing with data, or importing the design only.

John W. Vinson[MVP]