Primary Key no longer assigning consecutive #'s 1

[monkeysee]

I have a simple table for addresses. The AddressID is the primary key. Presently there are 4900+ records, last primary key # assigned was 4951.

When trying to add a new record, I am getting a duplicate primary key error. I watched to see what # access tries to assign to the new record and, indeed, it is trying to assign a record to a number that already exists (which was in the 4500 range)!

What can be done to remedy this?

 

[PHV]

First, I'd try a Compact/Repair the database.
If the problem still persists, you may run an action query like this:
ALTER TABLE yourTable ALTER COLUMN AddressID COUNTER(4952,1);

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[monkeysee]

PHV,
Compact/Repair did not fix.
But your query did! Thanks so much!