What can I do to fix this? When I use AutoNumber in MSAccess, if the record was deleted, the numbers become nonsequanced, they are not in order anymore, and for example, if the record #18 was deleted, the numbers in AutoNumber would be ...16, 17, 19, 20.....18 is missing, so how to "refresh" the AutoNumber? Is it a bug in MS Access or am I setting up the column for AutoNumber wrong?