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

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" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
>
> 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
>

On Feb 20, 3:44 pm, "Bob Phillips" <bob....@somewhere.com> wrote:
> 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" <alex.hatzisa...@gmail.com> wrote in message
>
> news:(E-Mail Removed)...
>
>
>
>
>
> > 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- Hide quoted text -
>
> - Show quoted text -

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