[AccessD] Strange Citrix error when running Access with Excel*SOLVED"

Cool!
  ----- Original Message ----- 
  From: Hale, Jim<mailto:Jim.Hale at fleetpride.com> 
  To: 'Access Developers discussion and problem solving'<mailto:accessd at databaseadvisors.com> 
  Sent: Tuesday, October 26, 2004 9:43 AM
  Subject: RE: [AccessD] Strange Citrix error when running Access with Excel*SOLVED"


  Gregg,
  Logging into the console worked! Many thanks!
  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<mailto:Jim.Hale at fleetpride.com>> 
    To: 'Accessd (E-mail)<mailto:accessd at databaseadvisors.com<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<mailto:AccessD at databaseadvisors.com<mailto:AccessD at databaseadvisors.com>>
   
  http://databaseadvisors.com/mailman/listinfo/accessd<http://databaseadvisors<http://databaseadvisors.com/mailman/listinfo/accessd<http://databaseadvisors>
  .com/mailman/listinfo/accessd>
    Website: http://www.databaseadvisors.com<http://www.databaseadvisors.com/<http://www.databaseadvisors.com<http://www.databaseadvisors.com/>>
  -- 
  _______________________________________________
  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/>

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