Prev: run time error
Next: Fax Server Name
From: JohnJohn on 18 Jan 2006 11:45
There was a recent Windows Update that was run, and it likely adversely
affected the Data Environment object. I have since discovered that that's
where the problem is. I can't add a single Data Environment object, and when
I remove the one that is in our project, the problems I described below
vanish.

Thanks for your reply!
John

"Ken Halter" wrote:

> "JohnJohn" <JohnJohn(a)discussions.microsoft.com> wrote in message
> news:EA80F893-AAD0-4497-8496-70EB6FED2235(a)microsoft.com...
> > Hello. I am receiving the error in the subject line at compilation on the
> > following declaration within a form file:
> >
> > Dim rsBanks as ADODB.Recordset.
> >
> >
> > For what it's worth, I also receive a "Method '~' of object '~' failed"
> > error upon loading the project. I know this may not be enough
> > information,
>
> I've probably just never seen it... but this line looks "suspicious".
> Object=Excel.Sheet.8; EXCEL.EXE
>
> ....and, just for kicks, you might want to try starting a new project and
> just drop an ADODC control on the form and check the references list. It
> should add a reference to the correct ADO library version for that control.
>
> Also, if you have the source for the "one that works", compare its list of
> references against the ones you posted..
>
> Since this is happening while loading the project, you may have some DLL
> Hell going on with VB add-ins too. Use the add-in manager to remove any
> add-ins you don't use every single day.
>
> Windows Update can almost be considered a virus these days too. It'll
> "sneak" in new Office components, VB/SP6 components, etc, etc, and never
> tell you it did so until it's too late.
>
> --
> Ken Halter - MS-MVP-VB - Please keep all discussions in the groups..
> DLL Hell problems? Try ComGuard - http://www.vbsight.com/ComGuard.htm
> Freeware 4 color Gradient Frame? http://www.vbsight.com/GradFrameCTL.htm
>
>
>
From: Paul Clement on 18 Jan 2006 14:49
On Wed, 18 Jan 2006 07:40:07 -0800, "JohnJohn" <JohnJohn(a)discussions.microsoft.com> wrote:

? Paul,
?
? Thanks for your reply! I JUST found where my problem lies. There aren't
? any references listed as "MISSING". We have one Data Environment object in
? the project and several Data REport objects. The error is associated with
? the Data Environment object. I removed that obect from the project and the
? problems I described below vanished. However, when I attempt to add a new
? Data Environment into the project, I get the following:
?
? System error &H0004005 (-2147467259). Unspecified error.
?
? Now I gotta track that down. I'm wondering if I just need to reinstall
? VB...that somehow something related to Data Evironments was corrupted.

Yeah I'm not sure how to fix this one. If may require an uninstall and reinstall.


Paul
~~~~
Microsoft MVP (Visual Basic)
First  |  Prev  | 
Pages: 1 2
Prev: run time error
Next: Fax Server Name