DAO accessing Jet v4
I've written a program which uses the following code to open a database -
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.
daoDb.Open( strFullDBName );
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?
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
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!