I'm not the dbase designer on this, but a Citirx server guy looking to solve this. Hopefully the details are adequate to generate some options.
Design: In Access 2000 a Resources.mde dbase opens a form where I select a button that allows me to use another form where I select a “field” and “Run Report”. The result is that another form called “Pivot Table Form” opens. It contains what appears to be an imbedded Pivot Table from Excel 2000. The properties of this are in a Window called “Unbound Object Frame: Pivot Table”. The Data OLE Class is “Microsoft Excel 2000”. There is a button to “Edit Pivot Table Object” and when executed, Excel opens up a Worksheet entitled “Worksheet in Pivot Table Form”.
Error: When trying to refresh this worksheet, I get a “Problems Obtaining Data” error message.
Symptom: Before trying a refresh, I select “Pivot Table” and “Field Settings” I get the message “Pivot Table Saved Without Underlying Data. Use Refresh Command….”
Symptom: If I refresh first (and get the “Problems Obtaining Data” error message) and select “Pivot Table” and “Field Settings” I get the message “Pivot Table Not Valid”.
Symptom: This only happens on a Windows 2000 Terminal Server hosting Citrix XP. It works great on any other Office 2K workstation. I’ve updated the MDAC to 2.8 and uninstalled and reinstalled Office, doing a complete install and following the Terminal Server instructions. I run the processes as an admin account. I’ve compared ODBC info between the terminal Server and another PC where it works and found no noticeable differences.
I've been all over newsgroups, knowledgbases, but cannot come up with anything beyond what I've tried. What's so different about the TS/Citrix environment?
Thanks, Rick Virene Jacobs Engineering.
Design: In Access 2000 a Resources.mde dbase opens a form where I select a button that allows me to use another form where I select a “field” and “Run Report”. The result is that another form called “Pivot Table Form” opens. It contains what appears to be an imbedded Pivot Table from Excel 2000. The properties of this are in a Window called “Unbound Object Frame: Pivot Table”. The Data OLE Class is “Microsoft Excel 2000”. There is a button to “Edit Pivot Table Object” and when executed, Excel opens up a Worksheet entitled “Worksheet in Pivot Table Form”.
Error: When trying to refresh this worksheet, I get a “Problems Obtaining Data” error message.
Symptom: Before trying a refresh, I select “Pivot Table” and “Field Settings” I get the message “Pivot Table Saved Without Underlying Data. Use Refresh Command….”
Symptom: If I refresh first (and get the “Problems Obtaining Data” error message) and select “Pivot Table” and “Field Settings” I get the message “Pivot Table Not Valid”.
Symptom: This only happens on a Windows 2000 Terminal Server hosting Citrix XP. It works great on any other Office 2K workstation. I’ve updated the MDAC to 2.8 and uninstalled and reinstalled Office, doing a complete install and following the Terminal Server instructions. I run the processes as an admin account. I’ve compared ODBC info between the terminal Server and another PC where it works and found no noticeable differences.
I've been all over newsgroups, knowledgbases, but cannot come up with anything beyond what I've tried. What's so different about the TS/Citrix environment?
Thanks, Rick Virene Jacobs Engineering.
