Printable View
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?
hi
try inserting a none duplicate id on the primary key column
It still displays the same error message no matter what value i typed in the Primary Key Field
chinhow
Try repairing the Access database. Is your primary key column an Autonumber field. If yes you can't explicitly set a value.
my primary key is not a autonumber field