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:
- Start
- Run
- mmc -32
- File
- Add Remove Snap-in
- Component Services
- Add
- OK
- Console Root
- Component Services
- Computers
- My Computer
- DCOM Config
- 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
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)