I am trying to create new DAO class (from Visual Studio classwizard) to connect to Access 2000 database. Since MFC 6.0 uses DAO 3.5 and Access 2000 uses DAO 3.6, I did add the following line to the 'initinstance' fuction so that I can use DAO 3.6.
AfxGetModuleState()->m_dwVersion = 0x0601;
But still when I try to create a new class (using class wizard) derived from CDaoRecordset class, I get the error message saying 'unrecognized data format'. Do I have to do anything else to use Access 200 database. I did select dynamic MFC library linkage while creating the project.