Software

Ask something
Discussion Locked

AutoNumber field problems in Access97

0 helpful
5 replies

by cepaul

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

Occationally we have problems with "missing" numbers in an auto number field. I am the only one that has permission to delete records from this table, so I know that is not the reason for these missing numbers, as I've not deleted any records.
The database is on a server that occationally has problems, but that shouldn't create skipped numbers, or could it somehow?
I can't think of any logical explanations, and the missing numbers generate "problems" in record keeping.
1. What could be causing this?
2. How can I prevent this problem in the future?
Thank you

5 replies

by don christner

Instead of relying on autonumber, generate the number yourself. Write a little code to find the last number, add one to it, and store that number in your database.

Don

by dan_c

Missing numbers can also be generated when someone starts a new record, then hits escape to get out of entering it. Access helpfully still adds one to the autonumber.

This discussion is closed to new replies.