Citrix, Access and a transfer spreadsheet export problem

[CraigDolphin]

Hi.

I developed a db on a local verison of Access 2003 (saved in Access 2000 format). It works great thanks to much help from this forum.

I recently moved the db to a server and tested how it worked when using Access 2000 on a citrix platform. This is important since the users of the db will be using this accursed platform. A few things (vba functions) broke but I deleted the affected code. However, one thing 'broke' that I can't eliminate.

When I click a button on one form I have a transfer spreadsheet command run to export the output of a query to a particular xls file/location. However, in the citrix environment I get an error message "Formats that enable export as html, xls, or rtf are missing from the windows registry".

I'm guessing this has something to do with the citrix server setup. Is there anything I can do on my end to avoid this problem or, as I fear, am I stuffed?

Cheers,
Craig

 

[FoFa]

Either Office is not installed on the Citrix server, or an install without all the import/export filters is not installed. Basically the installation differes on the Citrix server than on your desktop. Same issue with your VBA code.

 

[CraigDolphin]

Hmm. Thanks for the reply. I thought that something like that might be the problem but I was hoping I could do something on my end to get around it. I guess not.

Thanks again.