J.3. Connection.OpenSchema Method Options
The following tables list the values you can specify for the Command.OpenSchema method's schema and restrictions argument.
J.3.1. Schema Argument Values
The Schema argument specifies the type of information to return and its values are defined in the following table.
We have included only those values that have meaning in Access. The four remaining values, adSchemaActions, adSchemaCommands, adSchemaFunctions, and adSchemaSets relate specifically to the Microsoft OLE DB Provider for OLAP Services library. For more information about these values, refer to the Microsoft KnowledgeBase.
|AdSchemaAsserts||0||Returns the constraints defined in the catalog. Unsupported by the Jet provider.|
|AdSchemaCatalogs||1||Returns the catalogs that are accessible from the database. Unsupported by the Jet provider.|
|AdSchemaCharacterSets||2||Returns the character sets defined in the catalog. Unsupported by the Jet provider.|
|AdSchemaCheckConstraints||4||Returns the check constraints (validation rules) defined in the catalog.|
|AdSchemaCollations||3||Returns the sort orders defined in the catalog. Unsupported by the Jet provider.|
|AdSchemaColumnPrivileges||13||Returns the privileges on columns that are available to, or granted by, a given user. Unsupported by the Jet provider.|
|AdSchemaColumns||4||Returns the columns of tables and views that are accessible to a given user.|
|adSchemaColumnsDomainUsage||11||Returns the columns that are dependent on a domain that is owned by a given user. ...|
Get Access 2003 VBA Programmer's Reference now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.