Hello everyone,

When I execute my REPLACE syntax this err msg occur:

* -------------------------------------------------------------------------
Connectivity error: Cannot insert explicit value for identity column in the table when IDENTITY_INSERT is set to OFF.
* -------------------------------------------------------------------------

Im using SQL 2000 as database and my only got 4 fields and only one of the is the primary:

[patno] [int] IDENTITY (1, 1) NOT NULL ,
[lastname] [char] (20) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[firstname] [char] (20) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[miname] [char] (1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL

I hope someone can help me how can I solve this err.

Thank you very much.

Marlon E.