Make a template for a database

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

SLP - 22 Oct 2004 23:33 GMT

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

Reply to this Message

Bradley C. Hammerstrom - 23 Oct 2004 00:36 GMT

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.

> 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
[quoted text clipped - 4 lines]
> thanks
> Lynn

Reply to this Message

Larry Daugherty - 02 Nov 2004 15:24 GMT

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

Signature

-Larry-
--

> 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
[quoted text clipped - 4 lines]
> thanks
> Lynn

Reply to this Message