Unanswered: need help quick.. restarting reference#..program goin live today
ok.. i am trying to restart the reference autonumber at 45000. I did it once it worked using the append to table query.... but now it is starting at the last number i deleted instead of the number i want and goin to the next... HELP!!!
After you delete your records and append your starting number record, perform a "compact and repair database". In the past, that is how I got the autonumber to reset. However that was Access 2K and prior versions.