PRB: Global MFC DAO Objects Cause Assertions

Last reviewed: August 7, 1997
Article ID: Q145992
4.00 4.10 WINDOWS NT kbprg kbprb kbcode

The information in this article applies to:

  • The Microsoft Foundation Classes (MFC) included with: Microsoft Visual C++, 32-bit Edition, version 4.0, 4.1

SYMPTOMS

An assertion can occur on line 729, 732, or 1314 of Daocore.cpp when you define an MFC DAO object that has its destructor called after the call to CWinApp::ExitInstance.

This will happen when an MFC DAO object is defined globally or as a member of a global object (like an MFC application's CWinApp-derived object).

CAUSE

CWinApp::ExitInstance() closes all open DAO workspaces by calling AfxDaoTerm() and removes them from the global workspace map. In the destructors for MFC DAO objects such as CDaoDatabase and CDaoRecordset, MFC tries to remove the workspace objects again.

RESOLUTION

Here are two workarounds:

  • 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();
       }
    
    

STATUS

This behavior is by design.


Additional reference words: recordset 4.00 4.10
KBCategory: kbprg kbprb kbcode
KBSubcategory: MfcDao
Keywords : MfcDAO kbcode kbprb kbprg
Technology : kbMfc
Version : 4.00 4.10
Platform : NT WINDOWS


THE INFORMATION PROVIDED IN THE MICROSOFT KNOWLEDGE BASE IS PROVIDED "AS IS" WITHOUT WARRANTY OF ANY KIND. MICROSOFT DISCLAIMS ALL WARRANTIES, EITHER EXPRESS OR IMPLIED, INCLUDING THE WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE. IN NO EVENT SHALL MICROSOFT CORPORATION OR ITS SUPPLIERS BE LIABLE FOR ANY DAMAGES WHATSOEVER INCLUDING DIRECT, INDIRECT, INCIDENTAL, CONSEQUENTIAL, LOSS OF BUSINESS PROFITS OR SPECIAL DAMAGES, EVEN IF MICROSOFT CORPORATION OR ITS SUPPLIERS HAVE BEEN ADVISED OF THE POSSIBILITY OF SUCH DAMAGES. SOME STATES DO NOT ALLOW THE EXCLUSION OR LIMITATION OF LIABILITY FOR CONSEQUENTIAL OR INCIDENTAL DAMAGES SO THE FOREGOING LIMITATION MAY NOT APPLY.

Last reviewed: August 7, 1997
© 1998 Microsoft Corporation. All rights reserved. Terms of Use.