Simple Question on AutoNumber

[cantene]

A simple Database question in MS Access:

I wish to ask if it is possible that I can manually set a field of autonumber type to a particular number by code and that number is not duplicate with an existing record when inserting records into the database? Or this will generate error?

Thanks

[chrisjk]

No, auto numbers cannot be modifed. Either you use them, or you don't is the philosiphy. If you want to have a custom auto-numbering routine, you need to change the fields type from autonumber to long or text (depending on what you want the id to look like).