DAO with Access 2000 DB
-
I have a DB in Access 2000 for which I'm trying to access from a VC++ executable using DAO. When I try to query the DB I get a dialog asking me to select a data source. If I convert the database back to a prior version which I believe is 97 format, it works fine. Might anyone know why I get the data source dialog and how I might be able to get these queries to work with a 2000 version of the DB? Also, is it possible to convert a 2000 DB to 95? I see that Access says it can convert back to a prior but I'm wondering if this prior version is 97 and not 95. Thanks! :confused: "Save a tree, use Email!"
-
I have a DB in Access 2000 for which I'm trying to access from a VC++ executable using DAO. When I try to query the DB I get a dialog asking me to select a data source. If I convert the database back to a prior version which I believe is 97 format, it works fine. Might anyone know why I get the data source dialog and how I might be able to get these queries to work with a 2000 version of the DB? Also, is it possible to convert a 2000 DB to 95? I see that Access says it can convert back to a prior but I'm wondering if this prior version is 97 and not 95. Thanks! :confused: "Save a tree, use Email!"
Check KB article Q236991. Basically, if you're linked to MFC DLL, this should be enough to enable DAO 3.6:
AfxGetModuleState()->m_dwVersion = 0x0601;
AfxDaoInit();There's C++ Q&A column in Jan'2000 issue of MSJ that also describes this. Tomasz Sowinski -- http://www.shooltz.com