Make a template for a database

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

Guest

I have created a database in access 2000 where I can log characters in a
story for someone who is writing a book. They want to use this for other
books that they plan on writing. Is there a way to make a database a
template where it retains the look in view form every time without having to
redo the database?

thanks
Lynn
 
SLP,

I had the same issue with my photo database. What I do is keep a blank
(empty of data) copy of the mdb in a 'Template' folder that can be copied,
renamed, and moved to a project folder for a new project. The way I make the
template is copy the most recent version of the databse (I'm always
improving things) and click a special command button that runs a series or
macros that delete the records from all appropriate tables. (The actual
deleting is done with Delete Queries--see Access Help on this). This works
very well for me.

Brad H.
 
Hi Lynn,

I hope you've already had your question answered but here goes anyway.

In Windows Explorer copy YourCurrentApplication. Move to YourNewFolder,
Paste YourCurrentApplication. Rename YourCurrentApplication to
YourNewApplication.

One by one, open the tables in YourNewApplication and delete all the
entries. You now have an empty database that looks exactly like the
existing one.

HTH
 
Back
Top