ADOX Fundamentals

Microsoft ActiveX Data Objects Extensions for Data Definition Language and Security (ADOX) is an extension to the ADO objects and programming model. ADOX includes objects for schema creation and modification, as well as security. Because it is an object-based approach to schema manipulation, you can write code that will work against various data sources regardless of differences in their native syntaxes.

ADOX is a companion library to the core ADO objects. It exposes additional objects for creating, modifying, and deleting schema objects, such as tables and procedures. It also includes security objects to maintain users and groups and to grant and revoke permissions on objects.

To use ADOX with your development tool, you should establish a reference to the ADOX type library. The description of the ADOX library is "Microsoft ADO Ext. for DDL and Security." The ADOX library file name is Msadox.dll, and the program ID (ProgID) is "ADOX". For more information about establishing references to libraries, see the documentation of your development tool.

The Microsoft OLE DB Provider for the Microsoft Jet Database Engine fully supports ADOX. Certain features of ADOX may not be supported, depending on your data provider.

This document assumes a working knowledge of the Microsoft Visual Basic programming language and a general knowledge of ADO. For more information about ADO, see the ADO Programmer's Guide. For more overview information about ADOX, see the following topics:

See Also

ADOX API Reference
ADOX Code Examples
ADOX Collections
ADOX Enumerated Constants
ADOX Methods
ADOX Object Model
ADOX Objects
ADOX Properties
ADO (Multidimensional) (ADO MD)
ADO Programmer's Guide