Auto-number PK and prior numbers

[Paul-NYS]

Hi


I have an Access DB with a VB 6.0 front-end. I have a table with a PK that uses an auto-number. I deleted from data from this table in the past, then re-added it back in again just now. However, now when I go to enter a record in this table from the VB executable, I am getting an error for duplicate keys--as the auto-number tries to use a number that already exists. This happens when I just enter a record directly in the table in the DB also.

Any idea how to fix this?

Paul

[June7]

Run Compact & Repair and if that doesn't fix review http://www.pcreview.co.uk/forums/res...-t3132856.html