[AccessD] Very slow table link refreshing

Good point - I'll have to ask if someone has the BE open.  If so it should
only be the IT guy.

Thanks!
Dan

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Steve Schapel
Sent: Friday, January 30, 2009 3:08 PM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] Very slow table link refreshing

Dan,

I have found that relinking is very fast if that machine is the only one
connected to the backend at the time.  Relinking if the backend is already
opened from another workstation is always much slower.  Does this apply in
your situation?

Regards
Steve

  From: Dan Waters 
  Sent: Saturday, January 31, 2009 10:04 AM
  To: 'Access Developers discussion and problem solving' 
  Subject: [AccessD] Very slow table link refreshing


  Hello to everyone!

  At one of my customer's sites, they have seen sometimes where table links
in
  the Access 2000 FE refresh the links very slowly to the Access 2000 BE
  tables on the server.  I've also seen this while I've been remotely logged
  in to the server and tried refreshing the table links from a FE to a BE.

  Normally this refreshing takes about 2-3 seconds for about 20 tables.  But
I
  timed this at 4 minutes one day.  CPU usage on the server was effectively
0
  at the time, and the maximum possible client connection is only 4.  Later
  that day we were back to about 2 seconds.

  I would like to know anyone has any thoughts on what I can look for in my
  system, or anything I can pass on to the IT guy for him to look at?

-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com