Prev: MS Access Mass/Bulk Insert into a table
Next: Reassigning numbers
From: Roger on 9 Mar 2010 18:02
we are running access97 through citix as a softgrid package

we have a specific continuous that, for some users, refreshes itself
so
slowly that you can see row after row being displayed

for other users, the refresh is less than a second (instantaneous)

after some testing we discovered how to fix the problem, which is to
set the
citrix session display mode (resolution) to no more than 1024 * 768

this causes an issue for those users that have a local desktop
resolution greater than
1024 * 768, the citrix session doesn't use their full local desktop

has anyone seen this problem ?
other than changing the citrix session resolution, could there be
another solution ?
From: Roger on 10 Mar 2010 13:33
On Mar 9, 4:02 pm, Roger <lesperan...(a)natpro.com> wrote:
> we are running access97 through citix as a softgrid package
>
> we have a specific continuous that, for some users, refreshes itself
> so
> slowly that you can see row after row being displayed
>
> for other users, the refresh is less than a second (instantaneous)
>
> after some testing we discovered how to fix the problem, which is to
> set the
> citrix session display mode (resolution) to no more than 1024 * 768
>
> this causes an issue for those users that have a local desktop
> resolution greater than
> 1024 * 768, the citrix session doesn't use their full local desktop
>
> has anyone seen this problem ?
> other than changing the citrix session resolution, could there be
> another solution ?

problem solved, my query was doing a couple of Dlookup's which is by
nature slow
the dlookup fields were on the far right of the continuous form
and depending on resolution, you may or may not scroll horizontally to
see those columns

so with higher resolution, if the field was displayed, refresh was
slow
with lower resolution, refresh was quick until you scrolled right

changing the query to use JOINs instead of Dlookups, fixed the problem
From: David W. Fenton on 10 Mar 2010 14:37
Roger <lesperancer(a)natpro.com> wrote in
news:505bb587-56b0-4be8-ac35-734c0966dcf9(a)d2g2000yqa.googlegroups.com
:

> problem solved, my query was doing a couple of Dlookup's which is
> by nature slow
> the dlookup fields were on the far right of the continuous form
> and depending on resolution, you may or may not scroll
> horizontally to see those columns

The slow domain functions with linked tables problem was solved in
later versions of Access, but you can get round them by using Trevor
Best's domain function replacements (tLookup, tCount, etc.):

http://easyweb.easynet.co.uk/~trevor/AccFAQ/downloads.htm#baslookup

--
David W. Fenton http://www.dfenton.com/
usenet at dfenton dot com http://www.dfenton.com/DFA/
 | 
Pages: 1
Prev: MS Access Mass/Bulk Insert into a table
Next: Reassigning numbers