PDA

View Full Version : CreateObject() fails: "ActiveX component can't create object" in Access 2010



hk106
07-17-2013, 12:08 PM
Hi,

Our company has been using a Microsoft Access application for several years. We all use Windows 7, 64-bit workstations and we can open the application fine. But while setting up the application for another user, it is failing on this line of VBA code:

Set objUser = CreateObject("project0.GetUser")

The original developers of this application have long since left the company and no one was sure was "project0.GetUser" was referring to, but reviewing the Tools > References list, I do see an unchecked reference called "project0", which is a DLL stored on the users local C drive.
We've verified that the problematic machine has read rights to the directory as well as the DLL file. This machine also has the same operating system and the same Microsoft Office installation (2010) as other users, and we've already tried an Office re-install. We've tried unregistering and reregistering the DLL file on that machine, but the error still appears.
Any ideas on what might be happening would be greatly appreciated.

Thank you.

stanl
07-18-2013, 12:39 PM
When you re-registered the DLL did you check in the registry for a valid ProgID. Often dll's are created from VB and have dependencies on runtime or other objects.