HI,

I am firing query "SELECT COUNT(*) FROM EMPLOYEE" from Visual basic and populating recordset

rs.open "SELECT COUNT(*) FROM EMPLOYEE" , ConnectionObject

MSGBOX RS.FIELDS(0).VALUE --Here is gives me error

Error Code: 3021
Error Description: Either BOF or EOF is True or the current record has been deleted. Requested operation requires a current record

If I try to move the recordset to the first record, before fetching it, even it is giving me an error.

What could be the reason behind this? The same query runs on other PCs, but it throws an error on specific machine.

Please help me out

you might want to issue a rs.MoveFirst statement before the MsgBox - see how that goes.

I am a loud man with a very large hat. This means I am in charge

rs.open "SELECT COUNT(*) AS QTT FROM EMPLOYEE" , ConnectionObject
if not ra.EOF then
   msgbox rs!QTT
end if

If all else fails, try creating a separate VARIABLE were you can save the value of RS.FIELDS(0).VALUE and the;
MSGBOX VARIABLE

It Ends Here