MDAC 2.5 SDK - OLE DB Providers
OLE DB Provider for Microsoft Jet

Provider-Defined Properties in DBPROPSET_JETOLEDB_TABLE

The DBPROPSET_JETOLEDB_TABLE property set contains the following Table properties.

Property ID	Description
DBPROP_JETOLEDB_HIDDENINACCESS	Type: VT_BOOL Typical R/W: R/W Description: Jet OLEDB:Table Hidden in Access Whether the object should be displayed through the Microsoft Access User Interface. VARIANT_TRUE—The object should be hidden in Microsoft Access. VARIANT_FALSE—The object should not be hidden in Microsoft Access. This property has no effect on whether the object is displayed through the OLE DB layer. ADO will also display hidden objects, even when running under Microsoft Access.
DBPROP_JETOLEDB_LINK	Type: VT_BOOL Typical R/W: R/W Description: Jet OLEDB:Create Link Determines whether ITableDefinition::CreateTable or ITableDefinitionWithConstraints::CreateTableWithConstraints should create a link to a remote data store instead of creating a table in the native store. VARIANT_TRUE—Create a link instead of a regular table. VARIANT_FALSE—Create a native table.
DBPROP_JETOLEDB_LINKCACHE_AUTHINFO	Type: VT_BOOL Typical R/W: W Description: Jet OLEDB:Cache Link Name/Password Whether authentication information for the link to the remote data store should be cached in the Jet database. VARIANT_TRUE—Authentication information will be cached. VARIANT_FALSE—Authentication information will not be cached.
DBPROP_JETOLEDB_LINKDATASOURCE	Type: VT_BSTR Typical R/W: R/W Description: Jet OLEDB:Link Datasource Remote data store to which to link. This property is used only when DBPROP_JETOLEDB_LINK is VARIANT_TRUE.
DBPROP_JETOLEDB_LINKEXCLUSIVE	Type: VT_BOOL Typical R/W: R/W Description: Jet OLEDB:Exclusive Link Determines whether a link should be created so that the remote data store is opened exclusively. This is used only when DBPROP_JETOLEDB_LINK is VARIANT_TRUE. VARIANT_TRUE—The remote data store should be opened exclusively. VARIANT_FALSE—The remote data store should be opened for multiuser access.
DBPROP_JETOLEDB_LINKPROVIDERSTRING	Type: VT_BSTR Typical R/W: R/W Description: Jet OLEDB:Link Provider String Jet connect string to be used when connecting to the remote data store. This is similar in function to the DBPROP_INIT_PROVIDERSTRING when used to connect to the Jet OLE DB provider, except that it applies only to a single table.
DBPROP_JETOLEDB_LINKREMOTETABLE	Type: VT_BSTR Typical R/W: R/W Description: Jet OLEDB:Remote Table Name Remote table to be used in the link. This might be different than the local name of the table/link. This property is used only when DBPROP_JETOLEDB_LINK is VARIANT_TRUE.
DBPROP_JETOLEDB_VALIDATIONRULE	Type: VT_BSTR Typical R/W: R/W Description: Jet OLEDB:Table Validation Rule Expression to be evaluated on a table to validate the values of a row before committing the row's changes. This operates in a fashion similar to SQL-92 CHECK clauses. This is very similar to DBPROP_JETOLEDB_COL_VALIDATIONRULE, but this rule can span multiple columns within the table, allowing for more complicated restrictions.
DBPROP_JETOLEDB_VALIDATIONTEXT	Type: VT_BSTR Typical R/W: R/W Description: Jet OLEDB:Table Validation Text Error string to display when the validation rule specified in DBPROP_JETOLEDB_VALIDATIONRULE is not met.