[X]My Assistant

[rzw0wr]

I am trying to use ADO rrecordset.

Do I need to set some reference for this?

As I remember from a few years back I did need to.


Thanks,
Dale

[theDBguy]

I think you do. I'm not sure if it can be late bound.

[WildBird]

Usually its Microsoft ActiveX Data Objects 6.0 Library. Setting a reference to it will get intellisense, just remember to fully qualify recordsets as DAO also has recordset objects.

CODE

dim rst as ADODB.Recordset

not

CODE

dim rst as Recordset

[cheekybuddha]

>> I'm not sure if it can be late bound. <<

You can late-bind.

In some instances you do not even need to do that. E.g.

CODE

  With CurrentProject.Connection.Execute("SELECT * FROM YourTable")
    If Not (.BOF And .EOF) Then
      Do Until .EOF
        Debug.Print .Fields(0), Fields(1), Fields(2)
        .MoveNext
      Loop
    End If
    .Close
  End With

The above will work without any ADO reference set.

You will need to know the numeric values of any ADO constants (and re-declare them to make your code readable)

As Coop says, make sure you fully qualify your object declarations. That also means qualifying existing DAO recordsets in your code.

Why do you want to use an ADODB recordset anyway?

[theDBguy]

Hi David. Thanks!