Re: To move or not to move to a Terminal Server
- From: "Albert D. Kallal" <PleaseNOOOsPAMmkallal@xxxxxxx>
- Date: Mon, 18 May 2009 12:27:42 -0600
The assumptions you are making are generally correct there's only a few
things I will add here:
Access 97 is not particularly good for releasing the processor and "idle
time" correctly. Access 97 is 10+ years old now and it is one of those
versions that was caught up in the transition between 16 bit computers and
32 bit computers. when running access 97 on a user's desktop, the fact that
it's a little worse and releasing the title processor time is not a big
deal, but when you're running multiple users on the same box such as
terminal services, and this can become a significant issue. I would suggest
that you use access 2003, or even the access 2003 run time.
The other issue that is significantly important is that even when you run
the system on terminal services, each individual user needs to get their own
copy of the individual front end. for some reason often when moving to
terminal services because everybody's theoretically to on the same computer,
this rule is changed, and access does not take well to what we call an
industry reentrant code.
so in terms of eliminating network problems, data corruptions, and a host of
a number of the issues, terminal services is gently of very good solution to
these type of problems and you'll usually get better performance as a bonus.
You likely can continue using access 97, but just remember it's going to run
the server processor a at little bit of a higher temperature range because
it does not "idle" the processor very well at all. This is also the case
when using access 97 on laptop, you find your legs getting very hot because
a97 doesn't always idle the processor.
There are other possible solutions to this scenario, such as moving the the
database to SQL server, but in terms of the least amount, the least amount
of reprogramming and least amount of changing your architecture, clearly
terminal services is you best choice especially since you're running an
already in you have it in house expertise.
using TS for all users means you'll never have to install or update
ms-access on the client side computers....
--
Albert D. Kallal (Access MVP)
Edmonton, Alberta Canada
pleaseNOOSpamKallal@xxxxxxx
.
- References:
- To move or not to move to a Terminal Server
- From: doyle60@xxxxxxx
- To move or not to move to a Terminal Server
- Prev by Date: Re: Join key of table
- Next by Date: Re: Find path to outlook.exe
- Previous by thread: To move or not to move to a Terminal Server
- Next by thread: Re: To move or not to move to a Terminal Server
- Index(es):
Relevant Pages
|
