Filter Object (JRO)

Access Developer Reference

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.