Re: Access 2000 with SQL Server - MultiUsers

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: Tony Toews (ttoews_at_telusplanet.net)
Date: 02/26/04 

Date: Wed, 25 Feb 2004 17:00:37 -0700

"Rhovey" <anonymous@discussions.microsoft.com> wrote:

>I have an Access 2000 front-end running on 25 computers
>which has ODBC links to two different databases on a SQL
>Server 2000 back-end. At greater than 20 users, the
>application freezes up on all the client computers for 2-3
>minutes. What are the concurrency issues with Access/SQL?

Does each user have their own copy of the FE? This is very likely
your problem.

However you really want to put the FE on each machine or place in a
user specific directory on the server. This will help avoid some
weird error messages when users are changing the same forms record
source, filters and such as well as corruptions.

I specifically created the Auto FE Updater utility so that I could
make changes to the FE MDE as often as I wanted and be quite confident
that the next time someone went to run the app that it would pull in
the latest version. For more info on the errors or the Auto FE
Updater utility see the free Auto FE Updater utility at
http://www.granite.ab.ca/access/autofe.htm at my website to keep the
FE on each PC up to date.

In a Terminal Server or Citrix environment the Auto FE Updater now
supports creating a directory named after the user on a server. Given
a choice put the FE on the Citrix server to reduce network traffic and
to avoid having to load objects over the network which can be somewhat
sluggish.

Tony 

--
Tony Toews, Microsoft Access MVP
   Please respond only in the newsgroups so that others can 
read the entire thread of messages.
   Microsoft Access Links, Hints, Tips & Accounting Systems at 
http://www.granite.ab.ca/accsmstr.htm

Relevant Pages

  • Re: Pros & Cons of sharing a front end MDB (Client workstation vs. Server)
    ... I specifically created the Auto FE Updater utility so that I could make changes to ... In a Terminal Server or Citrix environment the Auto FE Updater now supports creating ... all the high maintenance details. ...
    (comp.databases.ms-access)
  • Re: BE/ FE Question
    ... BTW the free Auto FE Updater can also do all this as well as creating ... I specifically created the Auto FE Updater utility so that I could ... In a Terminal Server or Citrix environment the Auto FE Updater now ... Tony Toews, Microsoft Access MVP ...
    (microsoft.public.access.security)
  • Re: Temprarily locking out other users?
    ... I specifically created the Auto FE Updater utility so that I could ... For more info on the errors or the Auto FE ... In a Terminal Server or Citrix environment the Auto FE Updater now ... Tony Toews, Microsoft Access MVP ...
    (microsoft.public.access.modulesdaovba)
  • Re: FE/BE question
    ... Uhm, Tony, did you mean "You could put the BE on the server as long as ..."? ... I specifically created the Auto FE Updater utility so that I could ... For more info on the errors or the Auto FE ... Tony Toews, Microsoft Access MVP ...
    (microsoft.public.access.tablesdbdesign)
  • Re: Sudden deterioration of network speed
    ... > Live Server NIC stats: ... > Adapter Reset Count: 0 ... > Auto Negotiation capability: YES ... > Media Speed Running: 100 Mbps Full Duplex ...
    (comp.unix.aix)