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