ADO compatibility between Excel XP and 2003

[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

 

[Bob Phillips]

Did they set a reference to the ActiveX Data Objects library in the VBIDE?

--
---
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

 

[acrobat74]

Did they set a reference to the ActiveX Data Objects library in the VBIDE?

--
---
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)




















- Show quoted text -

Grrr...damn it
This guy had his PC reset, so I guess the ADO references were lost.
Thanks for reminding me!