Wrox Home  
Search P2P Archive for: Go

  Return to Index  

access thread: error occur in modules cant find project or library in "Global gCnn As New ADODB.Connection"


Message #1 by "Elmer Espinosa" <elmerespinosa@y...> on Wed, 16 May 2001 23:41:28 +0800
Why if I declaring in the modules the code below always occur an error 

such as Cant find project or library ??? Please help me!!!!!





Private Type OutFileStuff

    fs(1 To POSSIBLENUMOUTFILES) As FileSystemObject

    ts(1 To POSSIBLENUMOUTFILES) As TextStream

End Type



and



Global gCnn As New ADODB.Connection



Thanks in advance!!! =3D)



Message #2 by "Pardee, Roy E" <roy.e.pardee@l...> on Thu, 17 May 2001 14:00:59 -0700
Sounds like a missing reference (in the VBA editor, go to Tools ->

References).  Those are windows script host objects you're wanting to

use--you'll need to reference scrrun.dll.  ADODB.Connection would be the

appropriate ActiveX Data Object library.



HTH,



-Roy



-----Original Message-----

From: Elmer Espinosa [mailto:elmerespinosa@y...]

Sent: Wednesday, May 16, 2001 8:50 AM

To: Access

Subject: [access] error occur in modules cant find project or library in

"Global gCnn As New ADODB.Connection"





Why if I declaring in the modules the code below always occur an error 

such as Cant find project or library ??? Please help me!!!!!





Private Type OutFileStuff

    fs(1 To POSSIBLENUMOUTFILES) As FileSystemObject

    ts(1 To POSSIBLENUMOUTFILES) As TextStream

End Type



and



Global gCnn As New ADODB.Connection



Thanks in advance!!! =3D)









  Return to Index