AutoNumber Field Reset, compacting does not help

Z

Zebra

I have an auto numeric field, every time I delete a record and compact the
database, the new record is not what is supose to be. for example, records
560,561, and 562.... I erase the record 562 and compact database. when I try
to add a new record it goes to 563. I am working on access 2000. thank for
help.
 
G

Guest

Compacting the database no longer resets autonumber fields,
except when the table is empty. MS just wasn't able to make
it work properly after going from A97 (Jet 3.5) to A2K+ (Jet 4).

There are code samples that show how to 'reset the seed' using
VBA, but I can't give you an example at the moment.

(david)
 
Top