Post reply

Access and SQL 2000 Merge Replication

  • September 20, 2006 at 7:53 am

    #94551

    Hi,

    I have a problem when using merge replication. My access application uses ADO and keyset recordsets to manipulate data in SQL 2000. Without replication on when I add a record and update the record identity key is returned to the recordset. However, when merge replication is active this does not happen - all I get is a 0.

    Does anyone have a solution for this that doesn't involve re-writing masses of code in my application. ?

    Thanks

    Stuart

     

     

  • September 21, 2006 at 6:38 pm

    #661891

    Make sure in your Merge Replication that you have assigned an identity range, this way each subscriber gets a specific range of identities to use to make sure that there are no duplicates.

    To do this on each article select the identity range tab and enter in the appropriate fields for your system.

    Please note that you will now get non sequential numbers in your database table, as inserts at each subscriber will use its own identity range.

    HTH, Jeremy

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply