Replicable Property

Applies To

Database Object, QueryDef Object, TableDef Object.

Description

Sets or returns a value that determines whether a database or object in a database can be replicated.

On a Database object, this property adds fields, tables, and properties to a database.
On a TableDef or QueryDef object, or table, query, form, report, macro, or module in a database, this property changes the object from local to replicable.

Setting and Return Values

On a Database object, setting this property to the text string "T" makes the database replicable. Once the property is set to "T", it cannot be changed; setting the property to "F" (or any value other than "T") returns an error message.
On an object in a database, setting this property to the text string "T" makes the object (and subsequent changes to the object) available at all replicas in the replica set. You can also set this property in the object's property sheet in Microsoft Access.

Remarks

When you create a new table, query, form, report, macro, or module at a replica, the object is considered "local" and is stored only at that replica. If you want users at other replicas to be able to use the object, you must change it from local to replicable. Either create the object at, or import it into, the Design Master and then set the Replicable property to "T".

The object on which you are setting the Replicable property might have already inherited that property from another object. However, the value set by the other object has no affect on the behavior of the object you want to make replicable. You must directly set the property for each object.