Managing Jet Security with ADO

Managing Access security in DAO was discussed in Chapter 6, and since the same methodology is used in ADO, we won't labor the point here. However, we will highlight the properties and methods available in ADO that aren't available in DAO.

The first thing to be aware of is that the ADO security objects are children of the Catalog object. For example, the Users and Groups collections are both accessed thus:

Dim cat As New ADOX.Catalog cat.ActiveConnection = CurrentProject.Connection

Debug.Print cat.Groups(0).Name Debug.Print cat.Users(0).Name

0 0

Post a comment