Reset Autonumber

[Alex P]

Is there any way to reset an autonumber field in Access 2002? I was
testing a form by putting some data in it, the ID number is set to
autoincrement. When I deleted the data the next record started at number
two. I would rather have it start over at number.

Thanks for your help in advance

Alex

 

[Vasek Jezek]

See http://support.microsoft.com/default.aspx?scid=kb;en-us;q287756

Vasek

 

[Alex P]

Thanks for your help. That's what I was looking for.

Alex