Hi;

   I have a wierd error encountered. I tried to used adodb connection which
I do not believe the ernomous of time spent in debugging. I encountered
error if I use "*" as field to select, example :

     strSQL = "SELECT * FROM lsql  "
     MsgBox "Field : " & rst.Fields("QLLUCD")
     MsgBox "Field : " & rst.Fields(0)

  Error encountered was:

     "either BOF or EOF is true, or the current record has been deleted.
Requested operation requires a current record"

 However, If I specified my select statement as below:

     strSQL = "SELECT QLLUCD FROM lsql  "
     MsgBox "Field : " & rst.Fields("QLLUCD")
     MsgBox "Field : " & rst.Fields(0)

The recordset is successful. Can gurus give me some help?

Thanks