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