Tech Off Thread

1 post

Forum Read Only

This forum has been made read only by the site admins. No new threads or comments can be added.

Access 2003 - Replication Data Changes

Back to Forum: Tech Off
  • User profile image

    As a rule of thumb When designing a Replication database system I try to keep table data changes to a minimum. This has meant only updating changed rows, adding new rows or removing deleted ones. All of this in the design master/replication master.

    Will column changes as opposed to row changes allow me to abandon my rule of thumb and use an update query to overwrite all rows, mostly with the same data and will the replication process know that the overwritten data has remained the same or will it cause it to be logged as changed thereby increasing the size of the MDB.

Conversation locked

This conversation has been locked by the site admins. No new comments can be made.