Deleting Primary Key value

[chinhow]

Hi, I have a Access table and ID is the primary key field for instance, but i can't add record anymore after i deleted one of the record. It showed me an exception error message with 'number has already presence'. But this problem solved when i exit my program and operate it again. Can anyone tell me what is the problem?

[CoMMiE]

hi
try inserting a none duplicate id on the primary key column

[chinhow]

It still displays the same error message no matter what value i typed in the Primary Key Field

[Mr.No]

chinhow

Try repairing the Access database. Is your primary key column an Autonumber field. If yes you can't explicitly set a value.

[chinhow]

my primary key is not a autonumber field