How can i set a range of 10000 to 79999 in Microsoft Access with Autonumber?

Answer 1

Auto number is reset using an append query. Go to Help and search for this phrase: Change the starting value of an incrementing AutoNumber field.

Each record added will get a new number in the autonumber field. You can change the increment, it is defaulted to 1. What do you want to do when you get to 79,999? Purge and restart? If so, you would have to do that with code, probably in a form, checking the field for the number before the last number, 79,998 and triggering your code if that number is reached.

Answer 2

the only way i can think of is to write some VB code to do this. You will retrieve the max record in the field and increment it by 1 using a loop. You can specify that when the above mentioned max number reach 7998 you generate an error.