I have a web database in access and I am trying to set up a new table. They key piece of this table needs to be a randomly generated ID number that is between 4-6 digits long. I know that when I set up a new table the ID field is set as "AutoNumber" but I can't seem to modify the properties of this field like I can in Non-web databases.
Is there a way to have a randomly generated ID number that is a specific length in a web database? If so, how can I do this (preferably without VBA since that is not Web compatible)?
Thank you