trying to access the db of access using VC++, my main view class is derived from CRecordView, I think the recordset should be always available to use without having to call m_pSet->Open().

I call m_pSet->MoveFirst() in the view class, get the error like

Attempting to scroll before or after the data

and I tested the m_pSet->IsBOF() , which returns true!

I suspect that the resultset is empty or closed somehow. Please help, I will wait online