dim ADODB.connection

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
 
B

Brendan Reynolds

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"
 

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

Similar Threads

Timescalevalue update gives error 1101 0
VBA - exporting serial letters to single documents 0
Visio: copy text of a master shape to User-define Cells (Variable) 0
error when connecting to access 2007 0
ADODB.Connection in Access 97 2
VBA ODBC Connection with 32bit and 64bit systems 2
Closing PDF file from Excel VBA (Adobe Reader, Adobe Acrobat, Browser) 0
How to implement two shifts per day with multiple teams 0

Top