inititalising Autonumber field in MS access [Archive]

Click to See Complete Forum and Search --> : inititalising Autonumber field in MS access

shanuragu

07-10-2003, 12:01 AM

Hi
How can I initialise autonumber to 0.
I did try by deleting all the records in that perticular table. Suppose the last auto number generated before deleting all fields is 56, then after deleting all records the new autonumber generated would be 57 not 1 whay??

Please help

ShaRa

rdoekes

07-10-2003, 07:46 AM

Does compacting the database help?

NatuScape

07-10-2003, 08:01 AM

Hi there!

This happens because Access is very stubborn ;) The best way to do this is copy the table into a new one. You can then delete the old one and rename the new one. Make sure this doesn't alter any queries you may have!

Cheers,
Natalia