G'day fron Oz
At 27/01/2014 07:18 PM, Graham Mandeno wrote:
>Somehow the "seed" of your table has got messed up. This is the
>value stored in the table which is assigned to the next record that
>is created. It appears that this seed has been changed to the value
>of an existing record, so a new record with this value cannot be
>saved because it is a unique/primary key.
>
>This could happen because of some kind of corruption, or it could be
>that an INSERT INTO query has been executed that adds a record with
>an explicit value for the autonumber field that fills a gap in the sequence.
>
>Either way, the first thing to try is a compact/repair.
Woe is me! I often do that as a first move. My excuse is that it was
very late at night in Oz and my limited brain was already asleep!
That has fixed the problem.
Many thanks,
Robin
| Reply via web post | Reply to sender | Reply to group | Start a New Topic | Messages in this topic (5) |
Tidak ada komentar:
Posting Komentar