Solution : Runtime Error # 429 - ActiveX Component Can't Create Object

Runtime Error # 429 - ActiveX Component Can't Create Object

For this error I recommend user to go to the Installer CD, and look for MDAC_TYP.exe in the "...\Support" folder (this way, user will don't need to worry about installing the wrong version of mdac_type.exe) and run it, it will re-install and fix most common components (*.DLL, *.OCX and *.TLB) such as ODBC ADO, DAO, EXCEL, etc, which also includes most core components to run Microsoft Access Database in Windows operating system. I recommended this method because it will make sure all the involved components are installed properly, rather than just fixing one problem.

Download Link:
Microsoft Data Access Components (MDAC) 2.8 SP1
http://www.microsoft.com/en-us/download/details.aspx?id=5793


- OR -


http://support.microsoft.com/en-us/kb/292054

Method 1

1. Click Start, and then click Run.
2. In the Open box, type regsvr.exe.
3. Re-register DAO350.dll.
   
   NOTE: You can obtain a copy of DAO350.dll at the following FTP address:
   ftp://ftp.microsoft.com/softlib/mslfiles/
   To register DAO350.dll, follow these steps:
   
   
   1. Click Start, and then click Run.
   2. In the Open box, type Regsvr32.exe C:\progra~1\common~1\micros~1\dao\dao350.dll
   3. Click OK.
4. Click Start, point to Settings, and then click Control Panel.
5. Click Add/Remove Programs.
6. Insert your Microsoft Office 97 CD, and then click Uninstall.
7. Delete the DAO folder from the hard drive.
8. Click Start, point to Settings, and then click Control Panel.
9. Click Add/Remove Programs.
10. Insert your Office 97 CD, and then click Install.
11. Repeat steps 4 through 6 to uninstall Office 97.
12. Click Start, and then click Run.
13. In the Open box, type eraser97.exe. (This file is also available at ftp://ftp.microsoft.com/softlib/mslfiles/.)
14. Repeat steps 4 through 6.
15. Repeat steps 8 through 10 to reinstall Office 97.

Method 2

Important This section, method, or task contains steps that tell you how to modify the registry. However, serious problems might occur if you modify the registry incorrectly. Therefore, make sure that you follow these steps carefully. For added protection, back up the registry before you modify it. Then, you can restore the registry if a problem occurs. For more information about how to back up and restore the registry, click the following article number to view the article in the Microsoft Knowledge Base:

322756 How to back up and restore the registry in Windows

1. Click Start, and then click Run.
2. In the Open box, type regedit, and then click OK.
3. In the Registry Editor, browse to HKEY_CLASSES_ROOT\LICENSES.
4. Click New on the Edit menu, and then click Key.
5. Type F4FC596D-DFFE-11CF-9551-00AA00A3DC45 to name the new key.
6. In the right pane, double-click Default for the key that you created.
7. Type mbmabptebkjcdlgtjmskjwtsdhjbmkmwtrak as the Value Data, and then press ENTER.
8. On the Registry menu, click Exit to quit the Registry Editor.

Method 3

1. Click Start, point to Settings, and then click Control Panel.
2. Click Add/Remove Programs.
3. Insert your Microsoft Office 97 CD, and then click Uninstall.
4. Click Start, and then click Run.
5. In the Open box, type eraser97.exe.
6. Rename the DAO folder in C:\Program Files\Common Files\Microsoft Shared4.
7. Click Start, point to Settings, and then click Control Panel.
8. Click Add/Remove Programs.
9. Insert your Office 97 CD, and then click Install.
10. Click Custom to add the Data Access Objects for Visual Basic.