I have an Access temp table to load the data that is going to be bound the form. So there is frequent operations like inserting data into this table; delete all the records in this table, etc.
The ID filed is the primary key field, and its properties are: Long Integer/Increment/Indexed:YES(no duplicates)
My question, this ID keeps increasing and might have overflow issue in the future. How couild we reset the ID field after every use? Any better design or fix for this kind of problem? Thanks.