Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 372
  • 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?
0
funnylearning
Asked:
funnylearning
1 Solution
 
paisleymCommented:
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

Featured Post

[Webinar On Demand] Database Backup and Recovery

Does your company store data on premises, off site, in the cloud, or a combination of these? If you answered “yes”, you need a data backup recovery plan that fits each and every platform. Watch now as as Percona teaches us how to build agile data backup recovery plan.

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