[AccessD] Using ADO for Security

Stephen Bond stephen at bondsoftware.co.nz
Fri Apr 25 18:50:09 CDT 2003


I am trying to do a couple of things in ADO with membership of groups in the MDW file.  I got the ADO code from ADH 2000 vol 2 ch 8 (Getz, Litwin et al), but it won't run  ('Run-time error 3251 - Object or provider is not capable of performing requested operation').  It bombs on line 5 below.

   1. Dim cat As ADOX.Catalog
   2. Dim usr As ADOX.User
   3. Set cat = New ADOX.Catalog
   4. cat.ActiveConnection = CurrentProject.Connection
   5. Debug.Print "The Users collection has " & cat.Users.Count & " members:"

I suspect a Reference (I always suspect a Reference!).  I suspect the file MSADOX.DLL ('Microsoft ADO Ext.2.6 for DLL and Security').    The code from the CD that comes with the ADH references 2.6, I have 2.5 on my HDD. 

Anyone?


Stephen Bond 


More information about the AccessD mailing list