Some stations respond fast other very very slow

[Focus]

I have 6 stations linked to same datatable in server under access 2000
runtime
the respond of 2 of them is fast
but the respond of other 4 stations is very very slow
have any idea ???
all stations scaned with antivirus
thanks

 

[Allen Browne]

Go to Tony Toews' Access web site at:
http://www.granite.ab.ca/accsmstr.htm
and work through his Performance FAQ.

There are several issues to address there, and you will find the one that is
causing you grief.