Failed to retrieve components whose CLSID is {00024500-0000-0000-c000-000000000046} in the com class factory because of the following error: 80070005

Source: Internet
Author: User
Tags microsoft access database
Create an Excel application Program Error:

Failed to retrieve components whose CLSID is {00024500-0000-0000-c000-000000000046} in the com class factory because of the following error: 80070005

Solution: configure the Excel application in DCOM:

To set up an Office Automation server under an interactive user account, follow these steps:

1. Log on to your computer as an administrator and use the full installation method to install (or reinstall) The office. To ensure system reliability, we recommend that you copy the content from the office CD-ROM to your local drive and install office from this location.
2. Start the Office application that you want to run automatically. This forces the application to register itself.
3. After running the application, press Alt + F11 to load the Microsoft Visual Basic for Applications (VBA) Editor. This forces VBA to initialize.
4. Close the application, including VBA.
5. ClickStart, ClickRunAnd then typeDcomcnfg. Select the application to run automatically. The Application name is as follows:

Microsoft Access 97-Microsoft Access database
Microsoft Access 2000/2002-Microsoft Access Application
Microsoft Excel 97/2000/2002-Microsoft Excel application
Microsoft Word 97-Microsoft Word basic
Microsoft Word 2000/2002-Microsoft Word documentation

ClickAttributeOpen the Properties dialog box for this application.

6. ClickSecurityTab. VerifyUse the default access permissionAndUse the default start permissionSelected.
7. ClickIdentifierTab, and then selectInteractive User.
8. ClickOKTo close the Properties dialog box and return to the main Application List dialog box.
9. InDCOM ConfigurationIn the dialog box, clickDefault SecurityTab.
10. ClickEdit Default Value. Verify that the following users are listed in the access permission. If not, add these users:

System
Interactive
Everyone
Administrators
IUSR _ <machinename>*
IWAM _ <machinename>*

*These accounts only exist when Internet Information Server (IIS) is installed on the computer.

11. Make sure that each user is allowed to access, and then clickOK.
12. ClickEdit Default Value. Verify that the following users are listed in the startup permission. If not, add these users:

System
Interactive
Everyone
Administrators
IUSR _ <machinename>*
IWAM _ <machinename>*

*These accounts only exist when IIS is installed on the computer.

13. Make sure that each user is allowed to access, and then clickOK.
14. ClickOKDisable dcomcnfg.

ReferenceArticle: Http://support.microsoft.com/default.aspx? SCID = KB; ZH-CN; 288366

If you have used identity simulation (<identity impersonate = "true"/> configured in Web. config), you need to delete it !...

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.