Problems with the Connection Object

After a recent course attended with Stephen Williams, I have used some of the script to connect to an access data table. I have now tested the connection in a .udl notepad/GUI tool and it works. However when I apply the 'GetData' sub which accesses the database via the .Connection oblect I get a error which reads: 'Comile error: User-defined type not defined'...with the .Connection part of the code being highlighted...

I suspect that I need to activate a reference library which responds to this object...can you please tell me which reference library I should activate?

I have already activated the following...
Visual Basic for Applications
Microsoft 11.0 Object Library
OLE Automation
Microsoft Office 11.0 Object Library
Microsoft DAO 3.6 Object Library
Microsoft SQL Parser Object Library 1.0

Regards

Rob Snelson
attended 13&14 Aug course in London