Primary Key and Violation

[Tarbuza]

How can I check while executing Insert that if it is a primary key violation then it should do Update?

What error code Access generates if it encounters inserting the same primary key? Thanks in advance for any help.

 

[mas5]

The error is 3022. If you look in access help you can find all of these types of error messages under the topic Microsoft Jet Error Message Reference. There are several ways to deal with this error. You can:

1) Check for duplicates before you try to insert the record

or

2) Check for the error after you have inserted/attempted to insert the record.