I've created a database to use for different events that I have at work. I
want to keep a seperate database for each event. How do I make this a
template so that it will restart each time as a new file?
That's not necessarily a good design, but if you insist... you'll want
to create a template once, by creating a new, empty database and using
File...Get External Data... Import to import everything from your
existing database. For tables that you want to start out empty, select
the import option to import "design mode only"; for "lookup" tables
which should contain data (say, a table of states for addresses),
import the whole table.
Make a copy of this whenever you want to start a new database.
And if you ever want to compare the data from one event with the data
from a different event, remember that *you* chose to set it up in a
way to make that task as difficult as possible! <g>
John W. Vinson[MVP]
