dim ADODB.connection

  • Thread starter Thread starter Dave Dawson
  • Start date Start date
D

Dave Dawson

Can anyone tell me why the following would generate a "User-Defined type not
defined" error?

Dim cnnFLDCW As ADODB.Connection

Dave
 
Probably you don't have a reference to the ADO object library. In the VBA
editor, choose References from the Tools menu and look for "Microsoft
ActiveX Data Objects <version number here> Library"
 
Back
Top