[AccessD] Access XP Runtime and Citrix

I had a similar issue. From the archives: (I have to say I never solved it
to my satisfaction)

  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"

Response from Greg:
"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: Mike & Doris Manning [mailto:mikedorism at verizon.net]
Sent: Wednesday, February 15, 2006 4:13 PM
To: 'Access Developers discussion and problem solving'
Subject: [AccessD] Access XP Runtime and Citrix


I've got an application that my users generally run using Access Runtime ADP
FE on their local computers.  The "powers that be" have decided to switch
over to a Citrix network.  The problem. the application still runs and
generates no errors, but the forms do not show the data they are supposed
to.  If you run the application on the Citrix server itself, the data
changes just like it should.

 

Are there any gotchas I should know about when it comes to running an Access
ADP FE on a Citrix network?


***********************************************************************
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.