• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 377
  • Last Modified:

How do I connect VBA-Word to Access

In a Word 2007 VBA Macro I'd like to connect to an Access db. I am missing a setting or something to make the connection.  When I write  

Dim myDB as new adodb....

the adodb is not in the dropdown.
What have I left out to be able  to connect to a db?
1 Solution

within the script window you need to add the reference (under tools) Microsoft ActiveX Data Object 2.x library.

funnylearningAuthor Commented:
I'm working in the German version. It took a while to find where I could make this simple change labeled 'tools' in German its called 'Verweise' which means something else.
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now