[AccessD] Citrix and Access

I was looking at relatively large tables (50,000 orders and about 500,000
order details). But I bound the forms to stored procedures rather than
tables and applied what I call the Sally Rand principle (she was a famous
stripper) -- show them only enough to maintain their interest. In practice
that meant the sales "browser" showed sales from the last 30 days by
default, with buttons to expand the scope to 60, 90. 120 and All. I showed
only a few of the many columns. The browser was read-only and you could sort
by column. To edit an order you double-clicked on any column in the row of
interest. Then a master-detail form opened, containing the one order and its
details. That resulted in lightning-fast response.

Arthur

On Fri, Feb 6, 2009 at 4:53 PM, Dan Waters <dwaters at usinternet.com> wrote:

> Thanks Pedro,
>
> Luckily I won't be looking at large tables!  But I'll watch for the focus
> issues.
>
> Dan
>
> -----Original Message-----
> From: accessd-bounces at databaseadvisors.com
> [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Pedro Janssen
> Sent: Friday, February 06, 2009 3:16 PM
> To: Access Developers discussion and problem solving
> Subject: Re: [AccessD] Citrix and Access
>
>  Hello Dan,
>
> in the hospital where i work, we have access on citrix.
> We have only few troubles with citrix and access.With the citrix client
> version 8, we had focusproblems. But these focusproblems were for al office
> products under citrix. When client version 10 was installed. the where
> still
>
> some focusproblems, but these where minor. With focusproblems i mean. I
> close a table in access. Normally the focus then goes to the  database
> window, but with citrix the focus sometimes went to another program, that
> was open, or to the desktop.
> Another issue with citrix is that not al virusscanners are citrix proof.
> When you use one that isn't, you get sometimes (or many times) an annoying
> type delay. You type the letters, but they appear seconds later. Whit
> scrolling this isn't annoying, but a pain in the a......... When scrolling
> through a large table, and the delay gets to the scrolling, you better go
> do
>
> something else. The scrolling then is very slow, can't be speed up and you
> have to wait and wait.
>
> Succes
>
> Best Wishes
>
> Pedro
>
>
>
>
> ----- Original Message -----
> From: "Dan Waters" <dwaters at usinternet.com>
> To: "'Access Developers discussion and problem solving'"
> <accessd at databaseadvisors.com>
> Sent: Friday, February 06, 2009 7:19 PM
> Subject: [AccessD] Citrix and Access
>
>
> > One of my customers is considering placing their Access 2003 app on a
> > Citrix
> > server (we will have users in Asia).  He says that he believes that more
> > recent versions of Citrix are expected to work better with Access than in
> > the past, but he's not saying for certain.
> >
> > Does anyone have recent experience placing an Access app on a Citrix
> > server?
> > Any issues unique to Access?  Or any links to helpful information?
> >
> > Thanks!
> > Dan
> >
> >
> > --
> > AccessD mailing list
> > AccessD at databaseadvisors.com
> > http://databaseadvisors.com/mailman/listinfo/accessd
> > Website: http://www.databaseadvisors.com
> >
>
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>