Reset Identity Key

[danny123]

Hi there....

How can i reset the identity key?

Thanks
Danny

 

[The_Doc_Man]

? Explain just a little more please?

Do you mean the index supplied by an AUTONUMBER field? Search the forum (and Access Help) for Autonumber fields. In the forum, you should be able to find threads dealing with "Reset Autonumber"

If this is not what you meant, please specify.

 

[rainman89]

if that is the case u need to delete the records and do a compact and repair. that will reset your autonumber... but why would u wanna do that?

 

[danny123]

Thanks for reply...
Presently autonumber is at 233 with increment of 1. But business wants to reset the autonumber to start with 400 with increment of 1.

Thanks
Danny

 

[rainman89]

i dont think u can set what values your autonumber is going to start at. Why do they want to start it at that #? are they using the autonumber for something other than the primary key?

 

[The_Doc_Man]

Please advise your business people that if the key is to have meaning, it cannot be an autonumber. If it is to be an autonumber, then it is what it is and should not be altered. It has no meaning and its pattern is only slightly predictable at best.