Gregg
greggs at msn.com
Mon Oct 25 15:58:51 CDT 2004
Jim, We've had similar problems. Terminal Services uses the console to open office objects from code interactively. We got around it by always having the console logged in (not pretty just works). If you still have problems you might try adjusting your DCOMCNFG to allow interactive access and launch permissions. ----- Original Message ----- From: Hale, Jim<mailto:Jim.Hale at fleetpride.com> To: 'Accessd (E-mail)<mailto:accessd at databaseadvisors.com> Sent: Monday, October 25, 2004 9:44 AM Subject: [AccessD] Strange Citrix error when running Access with Excel I have a database that populates Excel budget spreadsheets from Access tables and also opens Excel spreadsheets and extracts data. I am using Office 2000 and DAO 3.6. The code runs flawlessly on my machine. On the Citrix server, however, the code to extract data from spreadsheets runs fine but the code to populate spreadsheets tells me that the interface does not support this operation. References are okay and permissions seem ok since I can save the spreadsheet (sans the data) through automation. Why automation works in one direction but not the other is beyond me. Any suggestions? TIA Jim Hale *********************************************************************** The information transmitted is intended solely for the individual or entity to which it is addressed and may contain confidential and/or privileged material. Any review, retransmission, dissemination or other use of or taking action in reliance upon this information by persons or entities other than the intended recipient is prohibited. If you have received this email in error please contact the sender and delete the material from any computer. As a recipient of this email, you are responsible for screening its contents and the contents of any attachments for the presence of viruses. No liability is accepted for any damages caused by any virus transmitted by this email.-- _______________________________________________ AccessD mailing list AccessD at databaseadvisors.com<mailto:AccessD at databaseadvisors.com> http://databaseadvisors.com/mailman/listinfo/accessd<http://databaseadvisors.com/mailman/listinfo/accessd> Website: http://www.databaseadvisors.com<http://www.databaseadvisors.com/>