How to connect Access 2000 with CDAOdatabase

[christinaL]

In my APP, I used CDAODatabase to connect Access97 successfully, but when I upgraded the database to Access 2000, the CDAODatabase can't recognize the Access2000 DB format. I use VC++ 6, and VisualStudio SP5. Any idea?

Thanks.

 

[Zyrenthian]

I have played around with this a bit and the easiest thing I found was I could either export the database in the 97 format OR create an ODBC source for the new 2k database and use CDatabase instead.

Matt

 

[KeithBrautigam]

Microsoft's advice is basically the same as Matt's. However, they also link you to some pages that show you how to use DAO 3.6 to connect to Access 2000 and, I think, 2002 databases:

http://support.microsoft.com/default.aspx?scid=KB;EN-US;Q232337