How do I clear an access template database

[Guest]

I have downloaded a couple of Access "template" databases from Microsoft
which I would like to use. The trouble is, there does not seem to be a
convenient way to clear the existing data, especially if an autonumber field
is involved. I suppose I could just wipe out all the records and not care
where the autonumber fields start, but it kind of bugs me. Any suggestions
would be great. Thanks.

 

[Joseph Meehan]

I have downloaded a couple of Access "template" databases from
Microsoft which I would like to use. The trouble is, there does not
seem to be a convenient way to clear the existing data, especially if
an autonumber field is involved. I suppose I could just wipe out all
the records and not care where the autonumber fields start, but it
kind of bugs me. Any suggestions would be great. Thanks.

Delete and then do a compact (under the tools menu)

If you care or even want to see the number, autonumber is a poor choice.
There are many things that can cause it to get out of sync. The only thing
you should use an autonumber for is to provide unique numbers.

 

[Guest]

Thanks, I'll try that. For the record, I downloaded the template from
Microsoft, and it came with the autonumber fields. They seem to be handy and
a pain, all at the same time. Thanks again.