A
acrobat74
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
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