Fields that are added to your tables when you replicate a database

Microsoft Replication Manager

Fields that are added to your tables when you replicate a database

When you replicate a database, Microsoft Access adds the following system fields to each replicated table in the replicated database:

Field Description
s_GUID A globally unique identifier for each record.
s_Lineage A binary field that contains information about the history of changes to each record.
s_Generation A field that stores information regarding groups of changes.

Notes

  • Additional fields (named Gen_Fieldname) are added for every Memo data type or OLE Object data type field in a table.

  • The s_GUID, s_Lineage, and s_Generation system fields are system objects that may or may not be visible in your tables. To make these fields visible in replicated tables, click Options on the Tools menu, click the View tab, and then select the System Objects check box. To see the fields, open a replicated table .

  • You can't change the information stored in the system fields in a replicated table.

  • For other considerations when replicating a Microsoft Access project, click .