Link to home
Start Free TrialLog in
Avatar of Dev2003
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
ASKER CERTIFIED SOLUTION
Avatar of mactep13
mactep13

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of Dev2003
Dev2003

ASKER

ok that seems to work fine, but what does it do?

does it still view the database as 2000 format? i am just worried incase it has an affect on the database relationships/functionality etc.
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
Avatar of Dev2003

ASKER

thats great , thank you for your help