Microsoft Jet and Replication Objects

Filter Object

        Properties       

Specifies criteria that limit the recordset of a replicated database.

Remarks

Use a Filter object to replicate a subset of the records in a database. With filters, you can create partial replicas that contain specific data according to the criteria. A Filter object can be contained in the Filters collection of a replica.

With the properties of a Filter object, you can:

• Specify the name of the table to which the filter is applied with the TableName property.
  
  
• Use the FilterType property to determine whether the filter is based on a table or a relationship.
  
  
• Specify the criteria that a record must satisfy in order to be replicated from the full replica with the FilterCriteria property.