Hi everyone,
I have a table with an autonumber primary key where I am trying to add records. Unfortunately the Autonumber seems to have "lost count" and for new records is suggesting a (random) lower number which has already been allocated.
This is weird! What is happening here?
Indeed, it may be because I have imported the table from another (migration table) and have written the old primary key column into the new primary key column. That seemed to work fine (and I was pleased because it will save me work) but I am worried that somehow now Autonumber is not displaying the valid next entry.
Anyway, is there a way to reset this so that MSAccess returns to selecting the next number in the Autonumber sequence?
Many thanks,
Alan