Cannot connect to Access 2000 database in Windows XP with ADO (2.5) 
Author Message
 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



Sat, 17 Jul 2004 17:07:46 GMT  
 Cannot connect to Access 2000 database in Windows XP with ADO (2.5)
More info:

Well. It seems like it's not a problem with Windows XP it self.
I installed XP on a new machine with nothing else on it. And it works just
as it should. No change of reference and no installation of JET SP or MDAC
was needed.
Difference to the machine that wont work, is that Office XP is installed.
And other smaller SW:s.

Best regards
Conny



Fri, 23 Jul 2004 15:43:03 GMT  
 
 [ 2 post ] 

 Relevant Pages 

1. VB, ADO 2.5, and Access 2000

2. ADO 2.5, Access 2000 and Texfiles...

3. ADO - connecting to a secured Access 2000 Database

4. Compressing an access database in ADO 2.5

5. VB6: Oracle 8/SQL Server 2000 compatibility problems using ADO 2.5 and SQL

6. VB6: Oracle 8/SQL Server 2000 compatibility problems using ADO 2.5 and SQL Syntax

7. VB6: Oracle 8/SQL Server 2000 compatibility problems using ADO 2.5 and SQL Syntax

8. Trouble with ADO 2.5 on NT4 (and not on 2000)

9. ADO Help doesn't appear (Access 2000, Windows 2000)

10. Visual Basic 3.0 for Windows and Foxpro 2.5 for Windows database

11. Ann: Live Chat on VenturCom Boot-NIC - Windows 2000/XP/XP Embedded Diskless Network Boot

12. MDAC 2.5 - ACCESS 2000 problems...

 

 
Powered by phpBB® Forum Software