Converting Jet 3.0 file to Jet 4.0
-
Does anyone know how to convert the Jet 3.0 file into Jet 4.0 format? The CDaoDatabase::CompactDatabase() can only specify dbVersion30 option. Looking at the available options it appears that MFC and DAO hasn't a option for dbVersion40.
-
Does anyone know how to convert the Jet 3.0 file into Jet 4.0 format? The CDaoDatabase::CompactDatabase() can only specify dbVersion30 option. Looking at the available options it appears that MFC and DAO hasn't a option for dbVersion40.
For opening the Access 2000 (Jet engine 4.0): You must write: AfxGetModuleState->m_Version = 0x601; Then you can open Access 2000 files with: m_db.Open("C:\\db1.mdb"); // ACCESS 2000 FILE ;) My month article: Game programming by DirectX by Lan Mader. Please visit in: www.geocities.com/hadi_rezaie/index.html Hadi Rezaie
-
For opening the Access 2000 (Jet engine 4.0): You must write: AfxGetModuleState->m_Version = 0x601; Then you can open Access 2000 files with: m_db.Open("C:\\db1.mdb"); // ACCESS 2000 FILE ;) My month article: Game programming by DirectX by Lan Mader. Please visit in: www.geocities.com/hadi_rezaie/index.html Hadi Rezaie
Yes you are correct, that is what is required to Open a Jet 4.0 file, but that doesn't convert the file from 3.0 format to 4.0.
-
Does anyone know how to convert the Jet 3.0 file into Jet 4.0 format? The CDaoDatabase::CompactDatabase() can only specify dbVersion30 option. Looking at the available options it appears that MFC and DAO hasn't a option for dbVersion40.
dbdaoint.h contains the following enumeration...
typedef enum DatabaseTypeEnum {
dbVersion10 = 1,
dbEncrypt = 2,
dbDecrypt = 4,
dbVersion11 = 8,
dbVersion20 = 16,
dbVersion30 = 32
} DatabaseTypeEnum;... so it seems that dbVersion40 equals 64. You can also use Object Viewer in Visual Basic to check the actual value from type library. Access 2000 should also have this defined. Anyway, let me know what happens with 0x40 :-D Tomasz Sowinski -- http://www.shooltz.com
-
dbdaoint.h contains the following enumeration...
typedef enum DatabaseTypeEnum {
dbVersion10 = 1,
dbEncrypt = 2,
dbDecrypt = 4,
dbVersion11 = 8,
dbVersion20 = 16,
dbVersion30 = 32
} DatabaseTypeEnum;... so it seems that dbVersion40 equals 64. You can also use Object Viewer in Visual Basic to check the actual value from type library. Access 2000 should also have this defined. Anyway, let me know what happens with 0x40 :-D Tomasz Sowinski -- http://www.shooltz.com
That worked: CDaoWorkspace::CompactDatabase( csOld, csNew, dbLangGeneral, 64 ); I was leaning that way but I thought I would just ask the experts here and save me some time. Thanks for your help.