DAO accessing Jet v4

I've written a program which uses the following code to open a database -

Code:

---

#include "afxdao.h"

...

CDaoDatabase daoDb;
daoDb.Open( strFullDBName );

---

When I pass the name of an Access database created using Access97 - the Open works correctly, but if I pass the name of a database created using Access2000, it returns an error saying that the database format is unrecognised.

I have both Access97 and Access2000 installed on my PC, and my Jet Driver version is 4.0......

I need to be able to open Access2000 db's, and don't need to open Access97 db's. Can anyone tell me how to get this working?

Thanks.

When I need a connection string I create a file on my desktop called conn.udl. Click it and a little wizard comes up prompting you for connection info (driver - Jet, excel, ODBC etc and other stuff). Then click OK and open the file in notepad. Youll find a usable connection string inside.

This works AOK for ADO...never bothered with DAO but it should work

PRB: Unrecognized Database Format Error with Access 2000 Database

Thanks very much for your help. I did search the Microsoft site, but didn't find the page you've posted - it's worked a treat!!

Thanks for the conn.udl tip aswell, that's actually really handy!