Other SoftwarePost questions here about stuff not directly related to a specific OS (Applications, Games).
Mission Statement
WindowsBBS is an online community dedicated to easily accessible technical support for those using Microsoft operating systems and other Windows software.
Our goal is to become the leading resource for computer users that require assistance with their day-to-day computer usage, including full support for networking PC's, virus & malware removal, system upgrades and general support questions.
When deleting a record in Access and that record contained an AutoNumber field, is there a way that when adding a new record, it will take it's AutoNumber.
For example if I have 100 records and I deleted record no. 10; Now when I add the 101th record is it possible that the Autonumber will replace the no. 10 instead of writing 101.
Thanks
Didn't find the information you thought to find? Check out these Similar Threads
As far as I know you cannot re-use or update auto numbers in Access records. This is an exerpt from Access help:
"A unique sequential (incremented by 1) number or random number assigned by Microsoft Access whenever a new record is added to a table. AutoNumber fields can't be updated. For more information, see the NewValues property topic."
