MS Access AutoNumber

[Nitin]

How can I reset(Start again from 1 after I delete all records from the
table) the 'Seed' of an AutoNumber field in a MS Access database.
Thanx
Nitin

 

[Cor Ligthert]

Nitin,

I thought that this was it.
http://support.microsoft.com/default.aspx?scid=kb;en-us;306287

I hope this helps?

Cor

 

[Riki]

How can I reset(Start again from 1 after I delete all records from the
table) the 'Seed' of an AutoNumber field in a MS Access database.
Thanx
Nitin

If your table is empty anyway, change it into Number, save, then change it
back to AutoNumber.

 

[Paul Clement]

¤ Nitin,
¤
¤ I thought that this was it.
¤ http://support.microsoft.com/default.aspx?scid=kb;en-us;306287
¤

This *may* work if the table is empty but it isn't reliable.

AFAIK you have to drop the column and re-add it.


Paul ~~~ (e-mail address removed)
Microsoft MVP (Visual Basic)