Microsoft KB Archive/189607

= DAO Error After Installing Visual Basic DAO Application =

Article ID: 189607

Article Last Modified on 1/23/2007

-

APPLIES TO


 * Microsoft Excel 97 Standard Edition
 * Microsoft Visual Basic 5.0 Professional Edition
 * Microsoft Visual Basic 6.0 Professional Edition
 * Microsoft Visual Basic 5.0 Enterprise Edition
 * Microsoft Visual Basic 6.0 Enterprise Edition
 * Microsoft Word 97 Standard Edition

-



This article was previously published under Q189607



SYMPTOMS
Microsoft Excel 97 may return the following error message when using DAO 3.5, if an application created with Visual Basic 5.0 that uses DAO is installed.

"Run-time error '429': ActiveX component can't create object"



CAUSE
If Microsoft Excel 97 is installed after an application created with Microsoft Visual Basic 5.0 that uses DAO is installed, Excel does not add the DAO design-time licensing key. This licensing key is required by Excel, but is not required by applications created with Visual Basic.

NOTE: The same licensing key is also required and added by Visual Basic 5.0. Because Visual Basic adds the same DAO design-time licensing key required by Excel, the problem does not occur if Visual Basic is installed.



RESOLUTION
To resolve this problem, add the DAO design-time licensing key to the Registry. Note that you should back up the Registry before you edit it. If you are running Windows NT, you should also update your Emergency Repair Disk (ERD).

WARNING: Using Registry Editor incorrectly can cause serious problems that may require you to reinstall your operating system. Microsoft cannot guarantee that problems resulting from the incorrect use of Registry Editor can be solved. Use Registry Editor at your own risk.

Step-by-Step Instructions

 * 1) From the Start menu, choose Run, enter "regedit", and press the ENTER key. The Registration Editor appears.
 * 2) In the Registration Editor, browse to HKEY_CLASSES_ROOT\LICENSES.
 * 3) From the Edit menu, select New, then choose Key. A new registry key appears.
 * 4) Enter "F4FC596D-DFFE-11CF-9551-00AA00A3DC45" (without quotes) as the name of the new key.
 * 5) In the right-hand window pane, double-click on the Default entry for the key you created.
 * 6) Enter "mbmabptebkjcdlgtjmskjwtsdhjbmkmwtrak" (without quotes) as the Value Data, and press enter.
 * 7) If you need to update multiple PCs, create a REG file for that key by choosing 'Export Registry File' from the Registry menu. Then, copy the REG file to other PCs and double-click on it to add the key to the registry.
 * 8) Choose Exit from the Registry menu to close the Registration Editor.



STATUS
Microsoft has confirmed that this is a problem in Microsoft Excel 97.



Steps to Reproduce Behavior
 Make sure that neither Visual Basic 5.0 nor Excel 97 have been installed. If one or both of them have been installed, then delete the following key:

HKEY_CLASSES_ROOT\LICENSES\F4FC596D-DFFE-11CF-9551-00AA00A3DC45

NOTE: The problem will not reproduce if the following key exists:

HKEY_CLASSES_ROOT\LICENSES\F4FC596D-DFFE-11CF-9551-00AA00A3DC45

 Install a simple Visual Basic 5.0 application that has a reference to DAO 3.5. Install Excel 97.  Start Excel and, in a new workbook, create a reference to DAO 3.5. Try to run the following code:

Sub Macro1 Debug.Print DBEngine.Version End Sub

Note that you get the error:

"Run-time error '429': ActiveX component can't create object".



<div class="references_section">