Access autogenerated columns

Occasional Visitor

I have a central table with an autogenerated key. The key has only be 4 digits for the last 7 years.  It is now generating a key of 8 digits. How do I adjust the generator to revert to the next 4 digit number. 

0 Replies