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: 283
  • Last Modified:

Word VBA project cannot open DB

Good day everyone. I have a project that was working fine. I made some slight alterations (changing path of the access database) and now every time I try to run it, it stops at opening opening the database. Any idea why? The location was changed to a different folder on the same server that is shared (just like where it as located prior). Below is a screenshot.
Error.jpg
0
sscal
Asked:
sscal
1 Solution
 
GrahamSkanRetiredCommented:
We can't see where the variable Db is defined.

My guess is that you have lost the Reference to the Microsoft DAO object library.
0
 
sscalAuthor Commented:
I totally orgot about the libraries. The coding for the project was copied over to a new macro on a different (test) document and I forgot to add the proper libraries. That part is working now but I am getting different error now. Any ideas? This is on a Windows Vista 64bit machine in case that makes a difference.
Error2.jpg
Error3.jpg
0

Featured Post

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

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