copying blank database

[Matt Edwards]

I have a database with moderately sophisticated
relationships and forms/subforms. I want to copy the
ENTIRE database into a blank database file, to use as a
template for future clients.

How can I copy the database and get the autonumber/primary
key of my main table to reset at 1? I've tried
copying "structure only" into the same database, and when
I go to File/Export it only lets me export one table at a
time, and I'm worried that will produce all kinds of
errors.

Thanks,

-ME

 

[Tim Ferguson]

I have a database with moderately sophisticated
relationships and forms/subforms. I want to copy the
ENTIRE database into a blank database file, to use as a
template for future clients.

The easiest way is also the oldest:

c:\> COPY h:\data\oldfile.mdb g:\newprojects\newfile.mdb

How can I copy the database and get the autonumber/primary
key of my main table to reset at 1?

First empty the tables like this:

DELETE FROM MyTable;

and then Compact the database using Tools | Database Utilities.

-- BUT -- the Great Rule of Wisdom shines forth, saying, "If you care what
value an Autonumber has, then you probably should not be using
Autonumbers."

Hope that helps


Tim F