Hi i am simply trying to create a ado recordset using the Like exprerssion in my sql statement i am using VB6 to Access97 db.
Set rsSYS = New ADODB.Recordset
SqlGet = "SELECT tblFFList.FileID, tblFFList.FileFullPath" _
& " From tblFFList " _
& " WHERE (((tblFFList.FileFullPath) Like '*DS System State Backup*'));"
rsSYS.Open SqlGet, cn, adOpenDynamic, adLockOptimistic
now rsSys.recount = -1
and when i get to rsSys.movefirst i get this error
"3021 Either BOF or EOF is True, or the current record has been deleted. Requested operation requires a current record."
this is driving me nuts, i need to search this field to return all records that have this in "DS System State Backup"
Now i can get the qry to run fine inside access, it is just when i try and create the recordset in vb