469,917 Members | 1,489 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,917 developers. It's quick & easy.

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?

Bruce

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

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

Gunny

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
info.
Oct 30 '07 #2
On Oct 30, 12:20 am, "'69 Camaro" <ForwardZERO_SPAM.To.
69Cam...@Spameater.orgZERO_SPAMwrote:
Yes, that is indeed the problem. Thanks for the very helpful reply!

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

Gunny

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
info.
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.

Jim

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
1 post views Thread by Waqarahmed | last post: by
reply views Thread by Salome Sato | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.