Microsoft Access 97
	Microsoft Access 2000
	Microsoft Excel 97 for Windows
	Microsoft Excel 2000
	Microsoft Word 97 for Windows
	Microsoft Word 2000
	Microsoft Access 2002
	Microsoft Excel 2002
	Microsoft Word 2002

SUMMARY

Microsoft does not recommend or support Automation to a Microsoft Office application from an unattended user account. For additional information on why Microsoft does not recommend automation under this context, click the article number below to view the article in the Microsoft Knowledge Base:

Q257757 INFO: Considerations for Server-Side Automation of Office

MORE INFORMATION

Automation of any Office application from an unattended, non-interactive user account is risky and unstable. A single error in code or configuration can result in a dialog box that can cause the client process to stop responding (hang), that can corrupt data, or that can even crash the calling process (which can bring down your Web server if the client is ASP). Office was not designed, and is not safe, for unattended execution on a server. Developers who use Office in this manner do so at their own risk.

Regardless, it may absolutely required to use Office in this manner. In these cases, special configuration must be done to avoid errors on Office startup. The steps below demonstrate how to configure Office to run as the interactive user account when it is started for Automation.

When you automate under the interactive user account, you should be aware of the following problems:

	Normally, the Interactive User is defined as the the user that is logged on to the local console (that is, the user who is physically at the computer). On computers that use Microsoft Windows 2000 Terminal Services or Microsoft Windows XP Terminal Services, the Interactive User is defined as a user who is logged on to the local console or a user who is connected to the computer through a remote Terminal Server client.
	When it is started through automation, the Office application always runs under the security context of the user that is doing the automation. If the user is logged on the server locally, the application runs under that user context. If a user is connected through a Terminal Server session, the application runs under that user account. Note that if you have multiple Terminal Server connections, the application runs under the context of each user who is logged on.
	When the Office application is started from a user context that does not have interactive privileges, such as the SYSTEM account, a user must be logged on to the server at the local console, regardless of whether Terminal Services is being used, or an error occurs and the application does not start. The following table shows the different scenarios you may run into when an Office application is configured to run as the Interactive User: Programming Action Logged On at Local Console? Results Programmatically create an instance of the application from a user session logged on the machine remotely through a Terminal Server Client Yes Success: The application starts under the desktop of the local or remote user that is running the Automation code. No Success: The application starts under the desktop of the remote user that is running the Automation code. Programmatically create an instance of the application from an account with a non-interactive SID (ASP, Service, etc.) Yes Success: The application starts under the desktop of the user that is logged on locally (the user that is physically at the machine). No Error: 0x8000401A - CO_E_RUNAS_LOGON_FAILURE The server process could not be started because the configured identity is incorrect. Check the username and password. Programmatically create an instance of the application from an MTS/COM+ package that is configured to run as INTERACTIVE Yes Success: The application starts under the desktop of the user that is logged on locally. Terminal Server sessions are not "interactive" in this case. No Error: 0x8000401A - CO_E_RUNAS_LOGON_FAILURE The server process could not be started because the configured identity is incorrect. Check the username and password. Programmatically create an instance of the application from an MTS/COM+ package that is configured to run as a specific user Yes Success: The application starts under the desktop of the user that is logged on locally, and not the specific user account for the package. No Error: 0x8000401A - CO_E_RUNAS_LOGON_FAILURE The server process could not be started because the configured identity is incorrect. Check the username and password.

Q288367 HOWTO: Configure Office Applications to Run Under a Specific User Account

Q288368 HOWTO: Configure Office Applications for Automation from a COM+/MTS Package

 

	Log on to the computer as the Administrator 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.
	Start the Office application that you intend to automate. This forces the application to register itself.
	After the application is running, press ALT+F11 to load the Microsoft Visual Basic for Applications (VBA) editor. This forces VBA to initialize itself.
	Close the applications, including VBA.
	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.
	Click the Security tab. Verify that Use Default Access Permissions and Use Default Launch Permissions are selected.
	Click the Identity tab and select The Interactive User.
	Click OK to close the property dialog box and return to the main applications list dialog box.
	In the DCOM Configuration dialog box, click the Default Security tab.
	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 IUSR_<machinename>* IWAM_<machinename>* * These accounts only exist if Internet Information Server (IIS) is installed on the computer.
	Make sure that each user is allowed access and click OK.
	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 IUSR_<machinename>* IWAM_<machinename>* * These accounts only exist if IIS is installed on the computer.
	Make sure that each user is allowed access and click OK.
	Click OK to close DCOMCNFG.
	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}"
	Restart the system. This is required.

REFERENCES

For more information about this topic, see the following articles in the Microsoft Knowledge Base:

Q169321 INFO: COM Servers Activation and NT Windows Stations

Q168877 HOWTO: Load a User's Hive Programmatically

Q158508 COM Security Frequently Asked Questions

Q184291 PRB: COM Objects Fail to Print When Called From ASP

Office Automation With Internet Scripting
http://support.microsoft.com/support/officedev/InetASP.asp

Additional query words: automation com service word access excel asp interactive

Keywords : kbASP kbAutomation kbDCOM kbGrpDSO
Issue type : kbhowto
Technology : kbWordSearch kbExcelSearch kbAccessSearch kbWord2000Search kbWord2000 kbWord2002 kbWord2002Search kbWord97 kbWord97Search kbAccess2000 kbAccess2002 kbAccess97 kbExcel2002 kbExcel2000 kbZNotKeyword2 kbAccess2000Search kbAccess2002Search kbExcel2000Search kbAccess97Search kbExcel97Search kbExcel2002Search kbZNotKeyword3