Re: Access 97 vs. newer versions

David W. Fenton wrote:
"Rick Brandt" <rickbrandt2@xxxxxxxxxxx> wrote in
news:PPu2g.18656$tN3.3242@xxxxxxxxxxxxxxxxxxxxxxxxxx:

Access 97 is not the best choice on machines where NT accounts are
set up and the user is not an admin of the machine, but even with
that I have seen few issues that were not easily solved. . . .

I've never seen any such problems. Word97 needs a registry
permissions change for the spell checker to work, but I"ve never had
to make any adjustments for Access. And all my clients for whom I'm
the sysadmin are *not* running as administrative users (which is
very bad practice).

. . . It is also not a good choice for Terminal
Server apps on newer versions of Windows as the "high percentage,
low priority" CPU usage of Access 97 that is normally not a
problem in other situations does seem to bog the machine down in
that scenario.

Really? Is A97 different from A2K in regard to the low-priority
Access message thread?

I can't say for sure as I have only our one anecdotal incident, but we were
using Access 97 runtime on a two server Citrix farm running on NT 4 TS Edition
for a few years. The system guys noticed the idle CPU usage, but I explained
what it was and we had no problems. When we upgraded those servers (new boxes
and server 2003) we suddenly had all kinds of resource problems. Killing the
Access instances always freed up the resources. It "appeared" that the same
idle CPU process was still there, but no longer acting as if it had low
priority.

We installed Access 2000 (did not remove A97 runtime) and I converted a copy of
the app to 2K file version and all the problems went away. Ever since that I
have been converting a copy of my app strictly for use on the Citrix farm.
Everyone who does not run off of Citrix still uses the A97 runtime.

--
Rick Brandt, Microsoft Access MVP
Email (as appropriate) to...
RBrandt at Hunter dot com


.

Relevant Pages

  • Re: Homegrown synchronization
    ... to check for update files in the Import DropBox for the server. ... similar to the import code used to update a remote backend). ... code to close the "sync" app. ... synch app, but only one at a time would be able to do synchs. ...
    (microsoft.public.access.replication)
  • RE: Beginners Questions
    ... We do use Windows form on the presentation layer which is on ... terminal server and call web services on the business logic side. ... of using "proxy" authentication on SQL Server. ... > I have written an app with a Windows Forms UI that is deployed to clients ...
    (microsoft.public.dotnet.distributed_apps)
  • Re: Ruby Enterprise App Design Advice
    ... Load balanced to send user to best server. ... FastCGI or SCGI - We would like to replace FastCGI with something ... certain instance and want to have a single session server (if I understand ... deals with login and logout and assigns an app server. ...
    (comp.lang.ruby)
  • RE: C++ Garbage Collector on VMS?
    ... And HW is usually not a problem in th app tier. ... One for App server, one for DB. ... Tiers were a great concept when HW could not keep up with the processing required by each tier and network speeds were slow and unreliable. ... In small to medium app environments, ...
    (comp.os.vms)
  • Re: Schannel and Session Renegotiation
    ... Schannel does not support the server sending app ... We are discussing the option of providing support for the client blowing off ...
    (microsoft.public.platformsdk.security)