How to connect ms access database in vc++?

See more:

MS-Access

VisualC++

#include "sql.h"
#include "Windows.h"

in OnRead() function

SQLRETURN rc;
CDatabase database;
CString strName,SqlString;
CString sCatID, sCategory,Username;
CString sDriver = "MICROSOFT ACCESS DRIVER (*.mdb)";
CString sDsn;
CString sFile = "E:\\Truck.mdb";
int iRec = 0;
sDsn.Format("ODBC;DRIVER={%s};DSN='';DBQ=%s",sDriver,sFile);
TRY
{
database.Open(NULL,false,false,sDsn);


rc = SQLAllocEnv(database);

SqlString =  "SELECT * FROM Trucklogin";

            rc=SQLExecute("SELECT * from Trucklogin");
            //database.ExecuteSQL(rc);
            AfxMessageBox(rc);

           
            recset.Open(CRecordset::forwardOnly,SqlString,CRecordset::readOnly);

CATCH(CDBException, e)
    {
        
        AfxMessageBox("Database error: "+e->m_strError);
    }
    END_CATCH;

how to find whether the values are accessing fron table or not??
please help me with some code.