472,096 Members | 1,369 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 472,096 software developers and data experts.

Slow opening local tables in Access 2003

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?


Oct 26 '07 #1
2 4441
Yes, that is indeed the problem. Thanks for the very helpful reply!

You're very welcome. Glad it solved the problem.


See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips and tutorials.
Blogs: www.DataDevilDog.BlogSpot.com, www.DatabaseTips.BlogSpot.com
http://www.Access.QBuilt.com/html/ex...ributors2.html for contact
Oct 30 '07 #2
On Oct 30, 12:20 am, "'69 Camaro" <ForwardZERO_SPAM.To.
Yes, that is indeed the problem. Thanks for the very helpful reply!

You're very welcome. Glad it solved the problem.


Seehttp://www.QBuilt.comfor all your database needs.
Seehttp://www.Access.QBuilt.comfor Microsoft Access tips and tutorials.
Blogs:http://www.DataDevilDog.BlogSpot.com...utors2.htmlfor contact
Is it possible (and if so, how) to set the default value of the
SubDataSheet Name property to None? In way new tables will not have
to be altere.


Nov 12 '07 #3

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

11 posts views Thread by DJJ | last post: by
3 posts views Thread by Mike Wilson | last post: by
1 post views Thread by IkyL234 | last post: by
2 posts views Thread by existential.philosophy | last post: by
reply views Thread by leo001 | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.