Reset Autonumber

[Edward]

Hi everybody,
I'm working on a new access project . During the test I have added several
records but now I deleted them and want to start from record one but somehow
access keeps the old info and although the records are deleted autonumber
doesnt start at "1". Is there a way to reset autonumber to start at 1 when
there is no record in the table?

 

[Pete D.]

Yes there is but, this sounds like you may be depending on the autonumber to
be something you can use. Autonumbers are not for users, they are for the
datafile and may not ever be in a proper sequence. To reset it,
http://support.microsoft.com/kb/812718

 

[Ken Sheridan]

You might also like to take a look at:


http://community.netscape.com/n/pfx...yMessages&tsn=1&tid=23839&webtag=ws-msdevapps


from where you can get a file which demonstrates a method of generating
sequential numbers, and allows for the number at which the sequence will
start when the next record is added to be reset. Roger Carlson's method at:


http://www.rogersaccesslibrary.com/...?TID=395&SID=83z7c11zc7b721d2a1e51989c53d7ffb


might also be of interest.

Ken Sheridan
Stafford, England