Automation Error

I have a MS Word template that a user fills out and saves to a specific drive and directory. I've written code in MS Access that looks @ this directory and takes all of the .doc files and populates the MS Access database. Everything was working fine. This morning I tried running a test from beginning (creating the MS Word doc) to end (Importing the docs.) and I am now receiving an Automation error: The object invoked has disconnected from its clients. I've also had someone else try on their PC and they too are receiving the same error. The import still works on the other persons PC, but not on mine. Has anyone experienced this problem before and where do I start. Any help is greatly appreciated.

I just performed the repair/compact on the database. I tried running my test and I am still receiving the automation error and the import did not working on my machine. Thank you. Is there anything else I can do?

Veeam is happy to provide a free NFR license (for 1 year, up to 10 users). This license allows for the non‑production use of Veeam Backup for Microsoft Office 365 in your home lab without any feature limitations.

If the issue is reference related, try creating a new EMPTY mdb file and then usinf File/Get External Data to import EVERYTHING from your old mdb. You will need to set the references again and also the startup options, but otherwise this is a quick option. It will clean the database better than a compress/repair.

This will also solve the problem if it was caused by a user with a more advanced version of Office running the app and therefor upgrading the references in it.

Finally, I would consider downgrading the ADODB code to old fashioned DAO, because its simpler and less flaky.

I did as you said, and I did not see any that has MISSING by them. The ones that I do have checked are as follows:
Visual Basics for Applications
Microsoft Access 9.0 Object Library
OLE Automation
Microsoft ActiveX Data Objects 2.1 Library
Microsoft DAO 3.6 Object Library
and
Microsoft Word 9.0 Object Library.

I recreated the database, and re-set my references and I am still getting the same error message, and no data is being imported.
I heard from the LAN staff, and no new installs or upgrades were performed.
If you have any other suggestions, please let me know.

Featured Post

Josh Coen and Jason Langer have prepared the latest edition of VCP study guide. Both authors have been working in the IT field for more than a decade, and both hold VMware certifications. This 163-page guide covers all 10 of the exam blueprint sections.

You need to know the location of the Office templates folder, so that when you create new templates, they are saved to that location, and thus are available for selection when creating new documents. The steps to find the Templates folder path are …

In Microsoft Access, learn how to “cascade” or have the displayed data of one combo control depend upon what’s entered in another.
Base the dependent combo on a query for its row source:
Add a reference to the first combo on the form as criteria i…

Add bar graphs to Access queries using Unicode block characters. Graphs appear on every record in the color you want. Give life to numbers.
Hopes this gives you ideas on visualizing your data in new ways ~
Create a calculated field in a query:
…