Resetting the Auto Number back to 0

[ankat]

A quick question.
I have just deleted all records from a table.
The address ID field has a primary key attached to it.
How do I set the autonumber back to 0
Many Thanks

 

[secureshell]

Just a suggestion, try deleting the auto number column (assuming you have no records in the table - as you said) and then creating it back again. {W r i t e C o d e A n d K i c k A s s}

 

[KenReay]

Hi

Compact the database and autonumber will start at 1 again (not zero).

But why would you want to do this?, autonumbers are not supposed to have meaning Regards

Ken Reay
Freelance Solutions Developer
Boldon Information Systems Ltd
UK