save existing database as template

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I would like to save a 'fresh' version of my database as a template:
First, I must clear all records. How? And secondly, is it possible to make
this a template?

Many thanks to those who respond!
 
Jorgie said:
I would like to save a 'fresh' version of my database as a template:
First, I must clear all records. How? And secondly, is it possible
to make this a template?

Many thanks to those who respond!
Click to expand...

Create a new blank database and import all of the objects into it. In the
Options area of the import dialog you can specify "Structure Only" for the
tables. As for using it as a template you could just make a copy every time
you need a new one and start working on the copy.

However; the need to do this often suggests an incorrect design. You're
not doing a file-per-month or a file-per-account or anything like that are
you?
 
Copy your database. Change its name to YourAppTemplate. Delete all
of the data from the tables except for those lookup tables which will
continue to be valid.

That is your "template" for this application. Each time you want to
start a similar application, copy and rename it.
 
Back
Top