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