PRB: Global MFC DAO Objects Cause Assertions

RESOLUTION

• Instead of using a global DAO object, define a global pointer to a DAO object. Be sure to destroy the MFC object before CWinApp::ExitInstance(). -or-
  
  
• Explicitly assign the CDaoWorkspace object to the DAO object rather than allowing MFC to create a CDaoWorkspace object implicitly. You can do this by passing the workspace objects and database objects into the constructors of the CDaoDatabase and CDaoRecordset objects respectively. Or you can explicitly set the CDaoDatabase::m_pWorkspace and CDaoRecordset::m_pDatabase variables before opening the CDaoDatabase or CDaoRecordset. Here is an example:

     CDaoWorkspace   wsp;
     CDaoDatabase    db;
     CMyDaoRecordset rs;
  
     BOOL InitializeDBStuff()
     {
        db.m_pWorkspace=&wsp;
        db.Open( _T("D:\\work\\assert.mdb") );
        rs.m_pDatabase=&db;
        rs.Open(dbOpenDynaset, _T("Select * from table1"));
        rs.Close();
        db.Close();
     }