Link to Access broke

[Mr930]

I have been working with a spreadsheet which extracts data from an Access .mdb. I have had no trouble, and now all of a sudden I get an error:

"user-defined type not defined"

on this line:

Dim DBConnection As ADODB.Connection

Something must have happened to my setup, but I can't tell what. Anybody know what this error means?

thanks
Fred Emmerich

 

[Andrew Poulsom]

Have you set a reference to Microsoft ActiveX Data Objects?

 

[Mr930]

I looked at that and there are several options for MS Active X data objects, none of them were checked. I checked the one that said 6.0 and everything seems to be back to normal. I wonder how it came unchecked?? Is this a setting for the spreadsheet or for Excel itself? I did modify this file on another machine recently, would that cause something like this to occur?

Either way, I am back in business!

thanks for the help
Fred EMmerich

 

[Andrew Poulsom]

References apply to the workbook.