Solved

How do I connect VBA-Word to Access

Posted on 2009-05-06
2
347 Views
Last Modified: 2012-05-06
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?
0
Comment
Question by:funnylearning
2 Comments
 
LVL 4

Accepted Solution

by:
paisleym earned 50 total points
Comment Utility
Hi,

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

hth
Marcelle
0
 

Author Closing Comment

by:funnylearning
Comment Utility
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

Featured Post

IT, Stop Being Called Into Every Meeting

Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

Join & Write a Comment

When creating Microsoft Word-based forms there may be a need to have a form field repeated throughout the whole document. For instance, with a company name, you may want this information repeated automatically throughout the document rather than man…
Shortcuts in Word Just the other day I had a training for Microsoft and they wanted me to show how well the new Windows and Office behaved on a touch device, which by the way is great, but it was only then that I realized that using keyboard shortc…
This video shows the viewer how to set up and create Footnotes in their document. Click on the References tab: Select "Insert Footnote": Type in desired text:
This video shows where to find the word count, how to display it, and what it breaks down to in Microsoft Word.

763 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

6 Experts available now in Live!

Get 1:1 Help Now