DOCUMENT:Q230485 07-MAY-2001 [visualc] TITLE :HOWTO: Create an Access 2000 Database with MFC DAO PRODUCT :Microsoft C Compiler PROD/VER:winnt:6.0 OPER/SYS: KEYWORDS:kbDAOsearch kbDatabase kbMFC kbOffice2000 kbGrpDSVCDB kbDAO360 ====================================================================== ------------------------------------------------------------------------------- The information in this article applies to: - Microsoft Visual C++, 32-bit Enterprise Edition, version 6.0 - Microsoft Visual C++, 32-bit Professional Edition, version 6.0 - Microsoft Visual C++, 32-bit Learning Edition, version 6.0 ------------------------------------------------------------------------------- SUMMARY ======= This article describes how to create an Access 2000 (Jet 4.0) database in Visual C++ 6.0. To create an Access 2000 database, it is necessary to use DAO 3.6 by setting the version of MFC to 6.01 at run time. For additional information, please see the following article in the Microsoft Knowledge Base: 236991 PRB: Unrecognized Database Format Error with Access 2000 Database Specify the DAO version explicitly as 0x40 in the CDaoDatabase::Create() method as described in the MORE INFORMATION section below. NOTE: Creating an Access 2000 database requires Jet 4.0 and DAO 3.6 installed on the computer. Jet 4.0 is installed with MDAC 2.1 and Office 2000. DAO 3.6 is installed with Office 2000. MORE INFORMATION ================ Steps to Create Access 2000 Database ------------------------------------ 1. Create an MFC dialog box-based application. 2. Add a command button to the dialog box resource. Add the following code to the command button handler: AfxGetModuleState()->m_dwVersion = 0x0601; CDaoDatabase db; db.Create("NewDatabase.mdb",dbLangGeneral,0x40); 3. Add the following code to Stdafx.h: #ifndef _AFX_NO_DAO_SUPPORT #include // MFC DAO database classes. #endif // _AFX_NO_DAO_SUPPORT 4. Compile and run your application. REFERENCES ========== For additional information, please see the following article in the Microsoft Knowledge Base: 236991 PRB: Unrecognized Database Format Error with Access 2000 Database Additional query words: Access2000 Office2000 Office 2000 DatabaseTypeEnum dbVersion40 ====================================================================== Keywords : kbDAOsearch kbDatabase kbMFC kbOffice2000 kbGrpDSVCDB kbDAO360 Technology : kbVCsearch kbAudDeveloper kbVC600 kbVC32bitSearch Version : winnt:6.0 Issue type : kbhowto ============================================================================= 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. Copyright Microsoft Corporation 2001.