Autonumber

G

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
 
L

Lynn Trapp

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

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)
 
J

Jeff Boyce

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