Hello,

I am trying to connect to a Access 2000 database using ODBC. The connect string that I am using does not work for Access 2000, but if I convert the database to Access 97 it works correctly. This is a problem because every time I wish to change the structure of the database I have to reconvert, make the changes and then convert back again.

Does anyone have a sample connect string that I can use to connect (I use the connection object to make the database link).

Thanks in advance.

Andrew