Reset Access Autoincrement Field
I’m still fighting with that Access database at work. I recently made a copy of our live database to a new database (for next year, kind of like a rollover) I wanted to delete records in a table and start over at ‘1′. The autoincrement field keeps going from where I left off, somewhere around 3800. Using Microsoft’s built in help had me chasing my tail, telling me to create a new table, run a query, delete the table. In short a mess. I did find, however that all one has to do is compact the database after removing the records and autoincrement is reset to ‘1′. Why the hell does MS describe the most convoluted way to do everything?
