Hello all,
I have an annoyance that is common to all of the Access 2003
applications I manage. All of the applications are split front end/
back end with a front end copy on each client workstation and back
ends on a common server. They are all secured with workgroup files
also residing on the server. Each front end has a mix of linked
tables and local tables. The annoyance I have noticed is that it
sometimes takes 10 to 15 seconds to simply open one of the local
tables in a copy of the front end by double clicking on it in the
database window. When I double click on one of these local tables, I
notice a flurry of network traffic indicated by the LAN connection
status icon in the system tray, then 10 to 15 seconds later the table
opens. However, if I open the front end database, then disable my LAN
connection, these tables open nearly instaneously. All of these local
tables are small lookup tables (one example has only two fields and
120 records). I have all of the Name Autocorrect options turned off.
The FE's are in Access 2000 format. I have compacted, repaired,
decompiled, recompiled all to no avail. At first I thought it might
have something to do with authenticating me against the workgroup file
on the server, but even when I copy the workgroup file to my
workstation and connect to it there the same behavior occurs. Why
would these small local tables take so long to open when I am
connected to the network yet open nearly instantaneously when I'm not?
Bruce