Export data to the Access - compile error user-defined type not defined RRS feed

  • Question

  • Hello,

    At the moment I am solving export of data to the Access. When the makros run, during the declaration, the PopUp error comes up. I spent a lot of time to repaire it.

    Thanks for help.

    Dim cn As ADODB.Connection  'here comes up the error


    Thursday, April 11, 2013 8:16 AM


  • Select Tools > References...

    Scroll down until you see Microsoft ActiveX Data Objects 2.1 Library.

    Tick its check box, then click OK.

    Regards, Hans Vogelaar

    • Marked as answer by VALL2 Thursday, April 11, 2013 9:52 AM
    Thursday, April 11, 2013 8:20 AM