[AccessD] Strange Citrix error when running Access with Excel

Thanks, I'll give it a go
Jim Hale

-----Original Message-----
From: Gregg [mailto:greggs at msn.com]
Sent: Monday, October 25, 2004 3:59 PM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] Strange Citrix error when running Access with
Excel


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.