Change DAO to ADO

[desperatemeasures]

I am trying to change my DAO to ADO, Is there any new reference I need to add? This is my code and I am getting this error message: Method or data member not found

Dim UserConn As ADODB.Connection
Dim UserRS As New ADODB.Recordset

Set UserConn = CurrentProject.Connection
Set UserRS = New ADODB.Recordset
UserRS.CursorType = adOpenDynamic
UserRS.LockType = adLockOptimistic
UserRS.Open "users", UserConn

With UserRS
.FindFirst "Name = '" & Me!txtUser & "'"

Any help would be appreciated, thanks

 

[neemi]

Have you got Microsoft Activex Data Object 2.1

Neemi