ADODB type missing?


Mike P

I have been working in 2007 the entire time, just had the db set to 2003
capability mode. Now I updated my Access 2003 db to Access 2007 using Import
External Data as I split the FrontEnd (program) from the BackEnd (data).
Some of my modules are getting a User Defined Type undefined, which is the
ADODB. The line that is failing in the 2007 version is
Dim cn As ADODB.Connection

Help ! ! Any ideas here?

Mike P

Got it! It was a references problem.

1. From any code module, select References from the Tools menu.
2. You may see an item marked ***MISSING*** - untick it.
3. Find Microsoft ActiveX Data Objects Library, and tick it.
4. Click OK.

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