C
CP
Hi, all. We have a home-grown Access application that approximately
50 users use to access different, but related, databases on different
Linux servers across the US. We are trying to combine all these
different databases into one database that everyone can access through
a Citrix server. In the initial (very) testing phase, we have found
some strange problems with our Access app that may be related to the
programming within the application or may be related to the Citrix
side of things (although when we try to do an analagous task going
just through Access itself we don't have the same problems. (Using
Access 2002 & Citrix Metaframe Program Neighborhood 9.150.39151. I
apologize in advance that I'm the Access app side of the team so if
you ask me anything about the Citrix setup, I'll have to go and ask
the other side for help.)
Here's the main show stopper we have found so far: The user specified
a particular table to use as the basis for a query and then clicks a
"Build Query" button. A bunch of parameters are checked to make sure
the user has completed the form and then these two lines are run:
DoCmd.OpenQuery strQueryFullName, acViewDesign, acEdit
DoCmd.RunCommand acCmdDesignView
When these commands are run in the "normal" application, the regular
query design form shows up with the table showing in the top portion
of the screen and the columns with rows for Field, Table, Sort, Show,
Criteria, or ready to accept criteria for the query. BUT when we run
the same procedure through a Citrix server, the initial query design
form shows up with practically nothing except some scroll bars. I can
enlarge the form and drag parts of it around so that I can see the
section where the table goes and the section where the criteria
columns go BUT no table shows and the column criteria section just
shows the names of the rows Field, Table, Sort, etc.). If I exit from
the query design form and then click the "Build Query" button again,
then I see the table itself BUT the criteria columns still don't
show. I can add fields to the query but can't specify sorting,
criteria, show, etc. When I try to go to SQL view (thinking that I
could enter the criteria there), I see a totally blank screen.
As I said before, when we just start Access through the Citrix server
and go to Query Design, it shows up perfectly.
I certainly hope that someone can give me an idea of what I should
look at to try to fix that. Otherwise, we may be dead in the water.
Thanks in advance for your help. Carol.
50 users use to access different, but related, databases on different
Linux servers across the US. We are trying to combine all these
different databases into one database that everyone can access through
a Citrix server. In the initial (very) testing phase, we have found
some strange problems with our Access app that may be related to the
programming within the application or may be related to the Citrix
side of things (although when we try to do an analagous task going
just through Access itself we don't have the same problems. (Using
Access 2002 & Citrix Metaframe Program Neighborhood 9.150.39151. I
apologize in advance that I'm the Access app side of the team so if
you ask me anything about the Citrix setup, I'll have to go and ask
the other side for help.)
Here's the main show stopper we have found so far: The user specified
a particular table to use as the basis for a query and then clicks a
"Build Query" button. A bunch of parameters are checked to make sure
the user has completed the form and then these two lines are run:
DoCmd.OpenQuery strQueryFullName, acViewDesign, acEdit
DoCmd.RunCommand acCmdDesignView
When these commands are run in the "normal" application, the regular
query design form shows up with the table showing in the top portion
of the screen and the columns with rows for Field, Table, Sort, Show,
Criteria, or ready to accept criteria for the query. BUT when we run
the same procedure through a Citrix server, the initial query design
form shows up with practically nothing except some scroll bars. I can
enlarge the form and drag parts of it around so that I can see the
section where the table goes and the section where the criteria
columns go BUT no table shows and the column criteria section just
shows the names of the rows Field, Table, Sort, etc.). If I exit from
the query design form and then click the "Build Query" button again,
then I see the table itself BUT the criteria columns still don't
show. I can add fields to the query but can't specify sorting,
criteria, show, etc. When I try to go to SQL view (thinking that I
could enter the criteria there), I see a totally blank screen.
As I said before, when we just start Access through the Citrix server
and go to Query Design, it shows up perfectly.
I certainly hope that someone can give me an idea of what I should
look at to try to fix that. Otherwise, we may be dead in the water.
Thanks in advance for your help. Carol.