Joe O'Connell
joeo at appoli.com
Mon May 19 15:18:00 CDT 2008
There are several tables in an application that have developed "holes" in the autonumber field. This is not a problem, except that Access has lost track of the next autonumber to use so it is reusing the autonumbers that are no longer in the table. For example, the autonumbers may go from 1-100 and then 200-300. Instead of using 301 as the next autonumber, Access uses 101. There is no problem until the autonumber for the new records reaches 199, then Access attempts to use 200 for the next autonumber. Since 200 is already in use, the record cannot be created. Has anyone else experienced a problem like this? What is the recommended method to correct this problem? Is there a way to reset the seed for the autonumber to force it to resume after the largest in the table? Joe O'Connell