Archive for May, 2012

Error while creating Excel object

Microsoft Excel Application entry missing in DCOMCNFG

On 64 bit system with 32 bit Office try this:

  1. Start
  2. Run
  3. mmc -32
  4. File
  5. Add Remove Snap-in
  6. Component Services
  7. Add
  8. OK
  9. Console Root
  10. Component Services
  11. Computers
  12. My Computer
  13. DCOM Config
  14. Microsoft Excel Application

Error while creating Excel object
1. In DCOMCNFG, right click on the My Computer and select properties.
2. Choose the COM Securities tab
3. In Access Permissions, click “Edit Defaults” and add Network Service to it and give it “Allow local access” permission. Do the same for <Machine_name>\Users.
4. In launch and Activation Permissions, click “Edit Defaults” and add Network Service to it and give it “Local launch” and “Local Activation” permission. Do the same for <Machine_name>\Users

,

No Comments

Solution fails on 64 bit system with error “Microsoft.Jet.OLEDB.4.0 provider is not registered on the local machine” and “Microsoft.ACE.OLEDB.12.0 provider is not registered on the local machine”.

Install: Microsoft Access Database Engine 2010 Redistributable

http://www.microsoft.com/en-us/download/details.aspx?id=13255

** Probably may need to install the Access 2007 version **

http://www.microsoft.com/en-us/download/confirmation.aspx?id=23734

If Offce 2003 (32 bits) already installed on the system, please

1. Remove the Office 2003 (32 bits)

2. Install above Access DB Engine (64bits)

3. Install back Office 2003 (32 bits)

,

No Comments