If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
create a new Access file using an existing file
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. |
#2
|
|||
|
|||
On Tue, 4 Jan 2005 17:19:05 -0800, "GermanSuzi"
wrote: 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] |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Access won't create sysem.mdw file automaticlly or manually why? | New Users | 0 | October 21st, 2004 11:04 AM | |
Access XP Compared to Access 2003 | Mardene Leahu | New Users | 1 | October 1st, 2004 05:11 AM |
Can I move the MDW file? | Damien McBain | General Discussion | 7 | September 28th, 2004 09:54 AM |
You do not have exclusive access... ERROR | Robin | General Discussion | 1 | July 6th, 2004 01:18 AM |