The problem is definitely caused by the insert trigger created by merge replication.

Thanks Chris:

Stuart

Hi Chris,

Thanks for looking at this.

My code in simple terms is as follows :

Dim intIdentReturn as Integer

Dim SqlRs as Adodb.Recordset

With SqlRs

    .Open "tblName", SqlConn, adOpenKeyset, adLockPessimistic

    .Addnew

     !Fieldname = "AddValueHere"

   ...

Hi Grovelli,

The problem is occuring in my Access application - the merge replication works fine so I did not consider there to be a problem there.