Solved

How do I connect VBA-Word to Access

Posted on 2009-05-06
2
353 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
ID: 24321121
Hi,

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

hth
Marcelle
1
 

Author Closing Comment

by:funnylearning
ID: 31578758
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

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Recursion / Iteration in Word 2013 Mail Merge 16 90
word 2016 1 32
Microsoft Word startup Issue 7 35
Word 2016 - Two similar docs - one has much larger filesize 8 25
Like many others, we try and discourage users from printing documents unnecessarily and instead send or share them electronically. However, this doesn't always work and documents are still printed. With this simple solution, if the user tries to …
Nice table. Huge mess. Maybe this was something you created way back before you figured out tabs or a document you received from someone else. Either way, using the spacebar to separate the columns resulted in a mess. Trying to convert text to t…
This Micro Tutorial well show you how to find and replace special characters in Microsoft Word. This is similar to carriage returns to convert columns of values from Microsoft Excel into comma separated lists.
In a previous video Micro Tutorial here at Experts Exchange (http://www.experts-exchange.com/videos/1358/How-to-get-a-free-trial-of-Office-365-with-the-Office-2016-desktop-applications.html), I explained how to get a free, one-month trial of Office …

830 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