Error:
Run-time error ’429’: ActiveX component can’t create object.
Error Message:
Causes:
- Data Access Objects (DAO) is not properly registered.
- Logged on user may not be an Administrator.
- You may not have the required permissions for required components [DLL/OCX] in the system32 and application folder
- It depends on which ActiveX Component the program is trying to initiate. It’s possible that the program looking for its custom DLL/OCX, that has been erased from the system.
- A DLL required by the object can’t be used, either because it can’t be found in the system, or it was found but it was corrupted.
- When you use Microsoft Access, you receive the this error message: A component [DLL/OCX] related to MS-Access might be missing or corrupted.
Solution 1: Unregister and Re-register the DAO350.dll using Regsvr32.
- Open Command prompt as Administrator
- type Regsvr32 /u “C:\Program Files\Common Files\Microsoft Shared\DAO\DAO350.DLL”.
- Click enter to unregister.
- type Regsvr32 “C:\Program Files\Common Files\Microsoft Shared\DAO\DAO350.DLL”.
- Click enter to register it.
Solution 2: Unregister and Re-register the Scrrun.dll using Regsvr32.
- Open Command prompt as Administrator
- type Regsvr32 /u “C:\Windows\System32\Scrrun.dll”.
- Click enter to unregister.
- type Regsvr32 “C:\Windows\System32\Scrrun.dll”.
- Click enter to register it.
Solution 3: Run the application always as administrator.
Right click the Application shortcut and Go to Properties set Run as Administrator.
Solution 4: Give Everyone “Full Control” permission to application path.
Right click the Application path > Properties > Click “Security” tab > Select “Everyone” give full control permission. > Click Apply & OK
Solution 5: Unregister and Re-register the FindMe.dll.
- Open the command prompt as Administrator
- type Regsvr32 /u “C:\RelyonSoft\<product>\FindMe.dll”
- Click enter to unregister it.
- type Regsvr32 “C:\RelyonSoft\<product>\FindMe.dll”
- Click enter to Register it.
Solution 6: Install msxml4.msi.
Download: msxml4.msi
Solution 7: Repair MS Office software.
- Open Control panel, click Add\Remove Programs and Repair MS Office.
- Or Un-install completely and install freshly.
Solution 8: Re-install the application. [Before un-installation take the backup of entire folder]
- Open control panel, click Add\Remove Programs and uninstall the application.
- Clean the application path.
- Re-Install the application And make sure that you are running the setup as Run as Administrator.
The above solutions didn’t work for me: eventually I fixed it by using the method described here:
http://www.ryadel.com/en/using-dao-from-excel-vba-vbs-without-ms-access-installed/