I went and looked at the references, as you suggested, and there doesn't appear to be any that have anything to do with Monarch. Furthermore, this database is sitting on a network share drive, and functions properly from all the other machines. I'm thinking there's a Monarch dll that didn't make it to this other machine that's not working. Does that sound possible?
I imagine this problem lies with a registry issue. When COM tries to instantiate the Monarch32 object, it has to look in the registry for the path to the executable responsible.
For Monarch, it will be in this key:
In that entry will be a path to the Monarch executable in 8.3 form, i.e.
I hope this helps.
I work in the IT department of my company. We have Monarch Pro 6. We've recently gone through the process of OS upgrades on our machines (2000 to XP pro). There's an Access database that we had custom built. Part of it's functionality imports reports from an outside vendor. Ever since the OS upgrade, my users have been getting the following error when attempting this:
Automation Error: The System Cannot Find The File Specified
This error occurs on the following line of VBA code:
Set MonarchObj = CreateObject("Monarch32")
I'm thinking that it's failing on trying to instantiate a Monarch object. As it turns out, Monarch Pro was not installed on the machine. We went ahead and did that, but are getting the same error. Does anybody know what the system is looking for?
Thanks in advance /b[/quote]