Auto Number Field Question...

[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

 

[Jeff Boyce]

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"?

 

[Nikos Yannacopoulos]

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

 

[Jessestonecedar]

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

Rich