RecordCount Query returns EOF and BOF
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