Cant open MS Access 2000 db
-
Hi, I cant access Access 2000 file from VC 6 Enterprise Edition. I tried opening the database and got the "Unrecognized database format ". Earlier that file was created in Access 97 format (thru VC) and it was working fine. The problem is that I converted that file to Access 2000. One thing is that Access 97 had Jet Version 3.0. And Access 2000 has version 3.5/4 (I got this info from registry). Any one any ideas? Any update I have to install? If yes, plz give me the URL. Thanks, Ammar
-
Hi, I cant access Access 2000 file from VC 6 Enterprise Edition. I tried opening the database and got the "Unrecognized database format ". Earlier that file was created in Access 97 format (thru VC) and it was working fine. The problem is that I converted that file to Access 2000. One thing is that Access 97 had Jet Version 3.0. And Access 2000 has version 3.5/4 (I got this info from registry). Any one any ideas? Any update I have to install? If yes, plz give me the URL. Thanks, Ammar
Hello, the codegurus around the world. ;) Configuration of Access 2000 issue is known well as the bug at VC++. You can find the solution in MSDN magazine or MSDN help, I think. Some header file, which I forgot, configures which version of Access is used in VC++ project. So, we simply add the new lines to this header file for Access 2000.:rolleyes: Have a nice day! -Masaaki Onishi-
-
Hello, the codegurus around the world. ;) Configuration of Access 2000 issue is known well as the bug at VC++. You can find the solution in MSDN magazine or MSDN help, I think. Some header file, which I forgot, configures which version of Access is used in VC++ project. So, we simply add the new lines to this header file for Access 2000.:rolleyes: Have a nice day! -Masaaki Onishi-
Actually I do not think this is a bug, the problem comes from the fact that the Access 2000 uses new version of DAO (3.6) and MFC by default supports version 3.5. To correct this all you have to do is chage version of MFC that you are using. This can be done with following line of code, just make sure that you call this before you try to open the database: AfxGetModuleState()->m_dwVersion = 0x0601; Pz
-
Actually I do not think this is a bug, the problem comes from the fact that the Access 2000 uses new version of DAO (3.6) and MFC by default supports version 3.5. To correct this all you have to do is chage version of MFC that you are using. This can be done with following line of code, just make sure that you call this before you try to open the database: AfxGetModuleState()->m_dwVersion = 0x0601; Pz
Hi, Many many thanks. I think your line of code works. Atleast it went thru that line in debug mode. :) One more thing... I am creating an access file in runtime with this code: db.Create("DOB.mdb", dbLangGeneral, dbVersion30); db.Execute("CREATE TABLE DOB (Name Text, Email Text)"); What happens is that this creates a file comaptible with Access97. Now I want to create a file for Access2000. dbVersion30 is for A97. I tried dbVersion35 and dbVersion40 but these two are undeclared identifier. How to create Access2000 mdb file? I have VC 6.0 Enterprise Ed. Ammar
-
Actually I do not think this is a bug, the problem comes from the fact that the Access 2000 uses new version of DAO (3.6) and MFC by default supports version 3.5. To correct this all you have to do is chage version of MFC that you are using. This can be done with following line of code, just make sure that you call this before you try to open the database: AfxGetModuleState()->m_dwVersion = 0x0601; Pz