ADO compatibility between Excel XP and 2003

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
 
B

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

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!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top