• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Chapter 23. WELCOME TO THE WORLD OF DATA... > CONVERTING A DATABASE TO A REPLICA

CONVERTING A DATABASE TO A REPLICA

Calling the MakeReplicable method on a database automatically converts the database to a replicable format. A new feature in Access 2000 is the ability to track data changes at the column (cell) level as well as the row (record) level. A column is the most basic unit of information recognized in replication when the ColumnLevelTracking, sometimes referred to as CLT, is set on a table. The ColumnLevelTracking property is a custom property, which exists both on the database and on each individual table. ColumnLevelTracking is the default on each table when the ColumnLevelTracking property is set to TRUE on the database. The database CLT property can be set only when making the database replicable. When a table's custom ColumnLevelTracking property is set to TRUE, nonconflicting fields are merged when changes are transmitted during synchronization. When ColumnLevelTracking is set to FALSE or equally when RowLevelTracking is set for the table in the table's property sheet in Access, if any field in a row (record) is modified, the whole record is marked as changed. Therefore, the whole record is updated when changes are transmitted during synchronization and individual fields aren't merged.

A ColumnLevelTracked table significantly reduces the potential for conflicts and simplifies the maintenance of replicated databases, if different users frequently edit the same data. ColumnLevelTracking creates a small performance hit, due to the added system columns and compare logic, and therefore shouldn't be used in cases where users are doing large updates to isolated tables—that is, tables other users wouldn't be updating.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint