ADO compatibility between Excel XP and 2003
Dear all,
I've built an XL application that resides on the intranet.
In this XL file, I use ADO to manipulate recordsets.
When I execute the application from my PC (XL 2002), everything works
fine.
Another user, however, who was running XL 2003 got the following error
message:
Error code: -2147220999
Error description: Method 'Open' of object '_Connection' failed.
The error occurs when the line of code that is ***HIGHLIGHTED*** tries
to execute:
Dim strCon As String
Dim con As ADODB.Connection
Dim rst As ADODB.Recordset
Set con = New ADODB.Connection
strCon = "Provider=Microsoft.Jet.OLEDB.4.0; " _
& "Data Source=" & strAppAccFullName & ";"
******* con.Open ConnectionString:=strCon ****** ' ERROR HERE
Is this a compatilibilty issue?
As I said, this executes fine with XL 2002.
Also, the connection string of the ADO connection is defined alright
at this stage.
Many thanks,
Alex
|