[AccessD] Using ADO for Security

Just a guess, but shouldn't it be 

Set cat.ActiveConnection=CurrentProject.Connection

???

Drew

-----Original Message-----
From: Stephen Bond [mailto:stephen at bondsoftware.co.nz]
Sent: Friday, April 25, 2003 6:50 PM
To: accessd at databaseadvisors.com
Subject: [AccessD] Using ADO for Security


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 
_______________________________________________
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com