Auto Number Field Question...

  • Thread starter Thread starter James
  • Start date Start date
J

James

Hi I have an Auto Numbger Field...

I have some test records in the database to test...

How can I delete the test records and make the Auto Numebr
Field go back to 1??

Many Thanks

James
 
James

A scan through this newsgroup (tablesdbdesign) will reveal a recurring theme
asking why you would care what value the Autonumber has. The Access
Autonumber is designed to provide a unique row identifier, and only rarely
needs to (or should) be displayed to users.

So, what are your business needs to have it reset to "1"?
 
James,

If you delete all the reords and compact the database, the numbering will
start over from 1 the next time you enter dat.

HTH,
Nikos
 
Also, simply create your own procedure that simulates the autonum counter
facility.

Rich
 
Back
Top