Simple Question on AutoNumber

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

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).