Dev2003
asked on
How to use a CDaoDatabase with an Access 2000 database
Hi,
I have written a little bit of code that opens a database, assesses the structure of the database and create an XML version, however it will only work if i change the database to 97 format.
What do I have to do to get this to work? Bearing in mind that the program is to be used by various companies and therefore various platforms will be used. It has to work on Windows 98 onwards.
thank you
I have written a little bit of code that opens a database, assesses the structure of the database and create an XML version, however it will only work if i change the database to 97 format.
What do I have to do to get this to work? Bearing in mind that the program is to be used by various companies and therefore various platforms will be used. It has to work on Windows 98 onwards.
thank you
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
There is a bug in the MFC 6.0 that uses DAO 3.5 (Jet 3.6). By telling the MFC to use version 6.01, you're telling it to use the DAO 3.6 (Jet4.0) format, which is the format for Access 2000 databases (and 2002/2003 as well). It will not affect on database relationships at all. It will just let you use the DAO objects with new db formats.
Your DB should not be converted to 97 format... use Native 2000 format and you will be able to read the database. If you have any other questions, let me know.
mactep
Your DB should not be converted to 97 format... use Native 2000 format and you will be able to read the database. If you have any other questions, let me know.
mactep
ASKER
thats great , thank you for your help
ASKER
does it still view the database as 2000 format? i am just worried incase it has an affect on the database relationships/functionalit