UPDATE
------
Bald Man Fixes COM Problems, Praises TechNet
Amherst, NY: After spending several frustrating hours attpempting to
correct the issue with COM object access, Hatton's Network
Administrator, John Morris, finally found and implemented the fix.
When interviewed, the only two things he would say were, "Who da man!?!"
and "Why didn't I think of that..."
John recently shaved his head in memory of a friend who recently died
from cancer.
The process, a 19 step nightmare, is included with this release for
anyone who might experience the same problem:
-------------------------------------------------------------------
1. Log on to the computer as the Administrator and create a new user
account that will automate Office. In our example, this account is named
OfficeAutomationUser . Create a password for this user account, and
select Never expire so that the password does not have to be changed.
2. Add the OfficeAutomationUser account to the Administrators group.
3. Log in to the computer as OfficeAutomationUser and install (or
reinstall) Office using a complete install. For system robustness it is
recommended that you copy the contents of the Office CD to a local drive
and install Office from this location.
4. Start the Office application that you intend to automate. This forces
the application to register itself.
5. After the application is running, press ALT+F11 to load the Microsoft
Visual Basic for Applications (VBA) editor. This forces VBA to
initialize itself.
6. Close the applications, including VBA.
7. On the taskbar, click Start , click Run , and then type DCOMCNFG .
Select the application that you want to automate. The application names
are listed below:
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 Document
Click Properties to open the property dialog box for this application.
8. Click the Security tab. Verify that Use Default Access Permissions
and Use Default Launch Permissions are selected.
9. Click the Identity tab. Select This User and type the username and
password for OfficeAutomationUser .
10. Click OK to close the property dialog box and return to the main
applications list dialog box.
11. In the DCOM Configuration dialog box, click the Default Security tab.
12. Click Edit Defaults for access permissions. Verify that the
following users are listed in the access permissions, or add the users
if they are not listed:
SYSTEM
INTERACTIVE
Everyone
Administrators
OfficeAutomationUser
IUSR_<machinename> *
IWAM_<machinename> *
* These accounts only exist if Internet Information Server (IIS) is
installed on the computer.
13. Make sure that each user is allowed access and click OK .
14. Click Edit Defaults for launch permissions. Verify that the
following users are listed in the launch permissions, or add the users
if they are not listed:
SYSTEM
INTERACTIVE
Everyone
Administrators
OfficeAutomationUser
IUSR_<machinename> *
IWAM_<machinename> *
* These accounts only exist if IIS is installed on the computer.
15. Make sure that each user is allowed access and click OK .
16. Click OK to close DCOMCNFG.
17. Start REGEDIT and verify that the following keys and string values
exist for the Office application that you want to automate:
Microsoft Access 97:
Key: HKEY_CLASSES_ROOT\AppID\MSACCESS.EXE
AppID: {8CC49940-3146-11CF-97A1-00AA00424A9F}
Microsoft Access 2000/2002:
Key: HKEY_CLASSES_ROOT\AppID\MSACCESS.EXE
AppID: {73A4C9C1-D68D-11D0-98BF-00A0C90DC8D9}
Microsoft Excel 97/2000/2002:
Key: HKEY_CLASSES_ROOT\AppID\EXCEL.EXE
AppID: {00020812-0000-0000-C000-000000000046}
Microsoft Word 97/2000/2002:
Key: HKEY_CLASSES_ROOT\AppID\WINWORD.EXE
AppID: {00020906-0000-0000-C000-000000000046}
If these keys do not exist, you can create them by running the following
reg file on your system:
REGEDIT4
[HKEY_CLASSES_ROOT\AppID\WINWORD.EXE]"AppID"="{00020906-0000-0000-C000-000000000046}"
[HKEY_CLASSES_ROOT\AppID\EXCEL.EXE]"AppID"="{00020812-0000-0000-C000-000000000046}"
[HKEY_CLASSES_ROOT\AppID\MSACCESS.EXE]"AppID"="{73A4C9C1-D68D-11D0-98BF-00A0C90DC8D9}"
NOTE : The sample .reg file is for Access 2000 or Access 2002. If you
are using Access 97, change the AppID key to:
"AppID"="{8CC49940-3146-11CF-97A1-00AA00424A9F}"
18. To avoid registry conflicts, install and run an NT service. Set the
identity of the service to run as OfficeAutomationUser , and select
Automatic as the startup type. For more information on creating a sample
Visual C++ NT Service, see the following Microsoft Developer Network
(MSDN) Web site:
Creating a Simple Win32 Service in C++
http://msdn.microsoft.com/library/techart/msdn_ntservic.htm
19. Restart the system. This is required.
-------------------------------------------------------------------
Hatton Humphrey wrote:
> Amherst, NY: Software developer Hatton Humphrey has a problem. He's
> loosing his hair, and at an alarming rate.
>
> "Before I tried messing with this ColdFusion stuff I was your average
> developer. Sure, I'd run into different problems here and there, but
> never something of this magnitude," Hatton said when asked what the
> source of his woes were.
>
> "Now I'm trying to provide something nice for a client and use Microsoft
> Excel to give them a downloadable list of items. It will work in one
> environment but not the other."
>
> Exasserbated, Hatton has turned to his network administrator and a
> popular COM website, cfcomet.com. Using these resources he has, "tried
> every option, thought or suggestion," to no success.
>
> In response to the elevated levels of stress, Hatton's hairline has
> responded by accelerating it's rate of recession. If things don't work
> out soon he may need to invest in Rogaine or one of the nicer
> non-prescription hair growth formulas.
>
> In a desparate plea for help, Hatton is sending out requests for
> assistance to fellow ColdFusion developers.
>
> "I've checked users permissions, created a new local user and assigned
> it to run the server... even reinstalled Excel at one point in time.
> None of it seems to make any difference. I keep getting 'Error trying
> to create object specified in the tag. COM error 0x80070005. Access is
> denied.' messages. I guess there are still things that I'm missing here."
>
> Anyone with information relating to this problem is encouraged to
> respond to posts and reposts of this message. The system in question is
> running Windows 2000 and IIS 5.0 with Microsoft Excel 2000 installed.
>
> "Please, any advice will help at this stage! I don't want to be bald
> before my daugther walks!"
>
>
>
______________________________________________________________________
Get the mailserver that powers this list at http://www.coolfusion.com
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
