Microsoft KB Archive/292054

= OFF97: Error Message: Error 429: ActiveX Component Cannot Create Object =

Article ID: 292054

Article Last Modified on 1/31/2007

-

APPLIES TO


 * Microsoft Office 97 Standard Edition
 * Microsoft Excel 97 Standard Edition
 * Microsoft Access 97 Standard Edition

-



This article was previously published under Q292054



IMPORTANT: This article contains information about modifying the registry. Before you modify the registry, make sure to back it up and make sure that you understand how to restore the registry if a problem occurs. For information about how to back up, restore, and edit the registry, click the following article number to view the article in the Microsoft Knowledge Base:

256986 Description of the Microsoft Windows Registry



SYMPTOMS
When you use a Microsoft Excel worksheet as a Data Access Object (DAO) data source for Microsoft Access, you may receive an error message similar to the following:

Error 429: activeX component cannot create object

NOTE: You may receive this error message may when you attempt to use Microsoft Visual Basic code to access the Data Base Engine version.



CAUSE
This issue can occur when DAO dynamic-link library (DLL) files are mismatched or when there are incorrect registry entries. This issue can also occur when there is a missing DAO design-time licensing key. This key is required by Microsoft Excel, but is not required by applications created with Visual Basic.



RESOLUTION
To resolve this problem, use the appropriate method.

Method 1
 Click Start, and then click Run. In the Open box, type regsvr.exe . 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:

 Click Start, and then click Run. In the Open box, type Regsvr32.exe C:\progra~1\common~1\micros~1\dao\dao350.dll  Click OK.</li></ol> </li> Click Start, point to Settings, and then click Control Panel.</li> Click Add/Remove Programs.</li> Insert your Microsoft Office 97 CD, and then click Uninstall.</li> Delete the DAO folder from the hard drive.</li> Click Start, point to Settings, and then click Control Panel.</li> Click Add/Remove Programs.</li> Insert your Office 97 CD, and then click Install.</li> Repeat steps 4 through 6 to uninstall Office 97.</li> Click Start, and then click Run.</li> In the Open box, type eraser97.exe. (This file is also available at ftp://ftp.microsoft.com/softlib/mslfiles/.)</li> Repeat steps 4 through 6.</li> Repeat steps 8 through 10 to reinstall Office 97.</li></ol>

Method 2
WARNING: If you use Registry Editor incorrectly, you may cause serious problems that may require you to reinstall your operating system. Microsoft cannot guarantee that you can solve problems that result from using Registry Editor incorrectly. Use Registry Editor at your own risk.


 * 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.

NOTE: Eraser does not run on operating systems later than Microsoft Windows 2000.

Additional query words: OFF97

Keywords: kbprb KB292054

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.