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 ?

On Mar 9, 4:02*pm, Roger <lesperan... (AT) natpro (DOT) com> wrote:
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

Roger <lesperancer (AT) natpro (DOT) com> wrote in
news:505bb587-56b0-4be8-ac35-734c0966dcf9 (AT) d2g2000yqa (DOT) googlegroups.com
:

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....htm#baslookup

--
David W. Fenton http://www.dfenton.com/
usenet at dfenton dot com http://www.dfenton.com/DFA/