Autonumber

[Guest]

Help!!!

I used to know how to do this, but I can't remember and
it's driving me nuts...

I have an autonumber field. I've deleted a few records and
now want to refresh the autonumber. Can't remember how to
do it.

Can someone remind me?

Thx-
Sar

 

[Lynn Trapp]

Compact the database after deleting the records. Bear in mind this will NOT
fill in any gaps that may exist.

 

[david epsom dot com dot au]

This facility has been removed from recent releases of JET.
If you really need to reset the autonumber, you need to
either use code, or empty out the table/create a new table
so that you can reset the autonumber to 1 by compacting
the database.

(david)

 

[Jeff Boyce]

Why do you care? Autonumber is intended for use as a unique row
identifier -- your users shouldn't need to see them.