Reset Autonumber to 1

[njwcad]

Can you please help
I heve a database and after much testing I would now like to implement. I have cleaned all test data from underlying tables and would like to reset all autonumbers to 0 on all my tables. Is this possible


Many thanks
Njwcad

 

[Golom]

Delete all the data from the tables and then compact the database. Autonumbers will then start at 1.

[small]No! No! You're not thinking ... you're only being logical.
- Neils Bohr[/small]

 

[RoyVidar]

Check out these methods/links/descriptions if what Golom says doesn't work

http://allenbrowne.com/ser-40.html

http://support.microsoft.com/?kbid=287756

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

You may have to remove relationships temporarily for them to work, though.

Roy-Vidar

 

[njwcad]

Golom and Roy Vidar

Many thanks it worked a treat

Njwcad