Re-set AutoNumber field

[uplink600]

Good Afternoon Dudes

I have deleted all records from a database and wish to re-set an autonumber field back to 1.

At present when we start re-entering records it starts from record 769 where the old records finished.

Can you please advise how we can do this.

Thanks

 

[Mile-O]

Empty the table and compact the database.

 

[KenHigg]

(Darn, I couldn't think of that to save my life... )

Ken