Jet database engine cannot find a record in the table......

[Levans digital]

I get the error message
The Microsoft Jet database engine cannot find a record in the table
"customertbl" with matching fields "customerID".

I then click "ok" However I decided not to add that record again and choose
to close the form before the form is closed it brings a second error message
(something about the data changes may be lost) and the form close. I then
reopen the form just to find that that specific "ID" is gone forever. What
can I do to avoid this. Basically the required ID field gets the focus and I
chose not to continue the record. please help?


----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.

http://www.microsoft.com/office/com...-9cc1-aa64433ac8aa&dg=microsoft.public.access

 

[Allen Browne]

I think you are talking about an AutoNumber field here?

Access assigns the autonumber as soon as you *start* to add a new record. If
you then abort the entry, the already assigned AutoNumber is not reassigned.
That makes sense in a multi-user environment, where another user may also
have started another reocrd and been assigned another number. Access has to
cope with the possibility that you may abort your entry while the later user
does not, so it simply avoids reusing assigned numbers.

If you abort, you may be able to compact the database to revert to the
previous number (depending on what version/service pack you have.)

 

[Levans digital]

Thanks very much. Yes the field is an auto number field.
Thanks