Unique Table, Unique Schema, Unique Catalog Properties-Dynamic (ADO)
Enables you to closely control modifications to a particular base table in a Recordset that was formed by a JOIN operation on multiple base tables.
Unique Table specifies the name of the base table upon which updates, insertions, and deletions are allowed.
Unique Schema specifies the schema, or name of the owner of the table.
Unique Catalog specifies the catalog, or name of the database containing the table.
The desired base table is uniquely identified by its catalog, schema, and table names. When the Unique Table property is set, the values of the Unique Schema or Unique Catalog properties are used to find the base table. It is intended, but not required, that either or both the Unique Schema and Unique Catalog properties be set before the Unique Table property is set.
The primary key of the Unique Table is treated as the primary key of the entire Recordset. This is the key that is used for any method requiring a primary key.
Unique Table must be specified before doing any custom resynchronizations. If Unique Table has not been specified, the Resync Command property will have no effect.
A run-time error results if a unique base table cannot be found.