[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?