Autonumber

  • Thread starter Thread starter Guest
  • Start date Start date
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
 
Compact the database after deleting the records. Bear in mind this will NOT
fill in any gaps that may exist.
 
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)
 
Why do you care? Autonumber is intended for use as a unique row
identifier -- your users shouldn't need to see them.
 
Back
Top