| Microsoft Office 2000/Visual Basic Programmer's Guide | |
The ADOX object model extends ADO to include objects for creating, modifying, and deleting database objects such as tables and stored queries. It also includes security objects to maintain users and groups and to grant and revoke permissions on database objects. To use ADOX, you must set a reference to the Microsoft ADO Ext. 2.1 for DDL and Security object library.
To work with security in previous versions of Access, you must use the DAO Users and Groups collections of the Workspace object to create and manage security user accounts, and then use the Permissions property of a Document object to set a user's or group's permissions on a database object. To use the ADOX object model to work with User-Level security, you use the Users and Groups collections of an open Catalog object to create and manage security user accounts, and use the GetPermissions and SetPermissions methods of the User and Group objects to set permissions on database objects.