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?
funnylearningAsked:
Who is Participating?
 
paisleymConnect With a Mentor Commented:
Hi,

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

hth
Marcelle
1
 
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.
0
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.

All Courses

From novice to tech pro — start learning today.