Autonumber Reset

[Newguy28]

Hi,

I have a autonumber function in my form, but i have deleted all the records and want to start again but the autonumber has not reset back to 1, is there a way to do this??

Thanks in advance.

 

[Rich]

Compact the db

 

[KenHigg]

I think the quickest way is to compact the db...

 

[snoko]

This doesn't seem to work in Access 2003 when you select the 'Compact and Repair Database...' option. Any ideas why ?

 

[Newguy28]

I have access 2003!!!!