Robin,
If you have 9370 records, why aren't new autonumber values at least 9370?
Do you know why the record could not be saved? Is there an issue with some enforced integrity?
Duane Hookom MVP
MS Access
----------------------------------------
> From: robinski@mymail.net.au
>
> I am using Access 2013 on a Win7 system.
>
> I have a membership table with the MemberID field as an auto number.
> There are 9370 records and today when attempting to add a new record
> MemberID=5260 was allocated which created a record which could not be saved.
>
> A second attempt allocated MemberID=5261 and the third attempt was
> MemberID=5262.
>
> What have I broken?
>
> Many thanks,
>
> Robin Chapple
__._,_.___
| Reply via web post | Reply to sender | Reply to group | Start a New Topic | Messages in this topic (2) |
.
__,_._,___
Tidak ada komentar:
Posting Komentar