
Cannot connect to Access 2000 database in Windows XP with ADO (2.5)
Hi.
Need advice on what to try to solv this new problem. Been reading in the
archives but haven't found any solution (yet).
We have a Access 2000 db and an VB 6.0 program with ADO controls to connect
to it. The database is protected with a workgroup file (.mdw).
This application works absolutely fine in Win 95,98,ME,NT and 2000. But when
installed on a brand new Windows XP Pro it can't log in to the database. We
get the usual "log in" form when the connection is to be done.
Our connection string look like this:
DE.MyDE.ConnectionString = "Provider=Data Source=" & DBPATH & _
"MyDB.mdb;JET OLEDB:System database=" & DBPATH & _
"Mymdw.mdw;JET OLEDB:Database Password=Mypassword;"
Our project reference is: Microsoft ActiveX Data... Library 2.5
I know Windows XP has a newer MDAC. Do I need to change reference?
Any suggestions turning me in the right direction would be most appriciated.
Best regards
Conny