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

Try naming the field count i.e.

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

I have tried with alias name, but it is throwing the same error.

Appart from this, If I write "SELECT * FROM EMPLOYEE", it returns the same error...