Provider support for ADOX

Applies to: Access 2013, Office 2013

Certain features of ADOX are unsupported, depending upon your OLE DB data provider. ADOX is fully supported with the OLE DB Provider for Microsoft Jet. The unsupported features with the Microsoft OLE DB Provider for SQL Server, the Microsoft OLE DB Provider for ODBC, or the Microsoft OLE DB Provider for Oracle are listed below. ADOX is not supported by any other Microsoft OLE DB providers.

Microsoft OLE DB Provider for SQL Server

Object or Collection	Usage Restriction
Catalog object	The Create method is not supported.
Tables collection	Properties are read/write prior to object creation, and read-only when referencing an existing object.
Views collection	Views is not supported.
Procedures collection	The Append and Delete methods are not supported.
Procedure object	The Command property is not supported.
Keys collection	The Append and Delete methods are not supported.
Users collection	Users is not supported.
Groups collection	Groups is not supported.

Object or Collection	Usage Restriction
Catalog object	The Create method is not supported.
Tables collection	The Append and Delete methods are not supported. Properties are read/write prior to object creation, and read-only when referencing an existing object.
Procedures collection	The Append and Delete methods are not supported.
Procedure object	The Command property is not supported.
Indexes collection	The Append and Delete methods are not supported.
Keys collection	The Append and Delete methods are not supported.
Users collection	Users is not supported.
Groups collection	Groups is not supported.

Object or Collection	Usage Restriction
Catalog object	The Create method is not supported.
Tables collection	The Append and Delete methods are not supported. Properties are read/write prior to object creation, and read-only when referencing an existing object.
Views collection	The Append and Delete methods are not supported.
View object	The Command property is not supported.
Procedures object	The Append and Delete methods are not supported.
Procedure object	The Command property is not supported.
Indexes collection	The Append and Delete methods are not supported.
Keys collection	The Append and Delete methods are not supported.
Users collection	Users is not supported.
Groups collection	Groups is not supported.