Hi ,

There is the only stored procedure which is called through MS access.

On this table are some triggers but I think that it should not be the problem.

Triggers provides updates of values when someone change a specific field of table.

If I update row (id = 3) from the table there is not problem ...proc works.

but when I want to update more then one row with same value (N_kplan = 112a) then appiers error.

Tbale Cis_OP_No was created manualy via MS Access

Cis_OP_No:

------------

id int

N_Kplan varchar

N_Cas100ks float

etc...

id N_kplan N_Cas100ks

----------------------------------

1 112a 15.78

2 112a 78.56

3 456b 78

4 741C 30.24