According to Microsoft, the Autonumber field is no longer reset after you compact an Access database. (article ID 287756). This is a bug. In this article, Microsoft provides a function that will reset Autonumber. They state that you can add the function to a module and run it in the Debug window.
I do sql queries in Access, but no Visual Basic programming. I need someone to explicitly state how (in Access 2007) you copy the function that Microsoft provides in the article ID 287756, add it to a module, and run it in Debug. Where do you copy and paste to; how do you get the debug window to appear.