473,699 Members | 2,135 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

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 4589
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_SP AM.To.
69Cam...@Spamea ter.orgZERO_SPA Mwrote:
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.comf or all your database needs.
Seehttp://www.Access.QBui lt.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 thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

11
17562
by: DJJ | last post by:
I am using the MySQL ODBC 3.51 driver to link three relatively small MySQL tables to a Microsoft Access 2003 database. I am finding that the data from the MySQL tables takes a hell of a long time to load making any kind linkage with my Access data virtually useless. I have the MySQL driver setup in as a USER DSN. The MySQL data is sitting out on a server and the Access database is running locally. The network connection is very...
5
2424
by: DFS | last post by:
Situation: Access 2003 front-end, containing links to Access 2003, SQL Server 2000, and DB2 tables. None of these tables are local. Hardware: IBM ThinkCentre, 10/100 Ethernet LAN Problem: Open a form or a report in Design mode, and bring up the Properties dialog. Now as I try to move from one Property to another, it's like Access is checking the entire recordsource of the form or report before moving the cursor focus. It literally...
3
3081
by: Mike Wilson | last post by:
Is there a way to open an OLE DB database from within Access? I would like to use the Access GUI with its table and query explorer to examine a database only available through an OLEDB provider interface. I have seen several references on how to open an OLE DB database through VBA/ADO code but I wouldn't know how to go from there to actually have the database available in the Access GUI...
4
7346
by: cvopicka | last post by:
i have found many refrences to access being slow over a netowrk but my boss and i just found this and i was hoping to get some help. on the local machine we have the Access 2000 format database open in access 2k3. this is also the machine that the database lives. we then from a tool bar in access call an external program to manipulate the database. and the process time is about 5.5 minutes then if we disable the network connection...
1
2010
by: IkyL234 | last post by:
I'm using Access2000. I have just designed a database which seems to be operating very slow on a network. There are currently only a few records in it. Should I be compacting it now before it gets busy with usage ? The database has OLE bounded fields where pictures are linked to a network folder where the pictures are kept. Will this linking of pictures to respective records over time hinder the speed of the database ?
7
26958
by: ddsvi78 | last post by:
I am a complete idiot when it comes to access. Now that said, I work for a computer security company and one of our customers came to us with an access problem. They had been running fine for a long time. Then about a month ago there main server that hosted all the .mdb files crashed. So they restored everything to a new server (I believe 2003 server). Everything was fine for 2 weeks, then one morning they came in and the queries were...
2
4267
by: dev | last post by:
Several years ago I developed an Access 97 runtime application. I have rewritten this application using Visual Basic 6 with an Access 2003 database. When I run the VB application with the database on the same PC, the performance is good. When I move the database to a different PC on my two PC network, the performance is slow. This is not the case with the original Access 97 application; it performs fast regardless of where the...
3
2613
by: lopedon | last post by:
I've got a performance issue in Access 2000 running on Windows 2000. Opening a table local to the MDB takes about 1-2 seconds normally. If I log out of the windows profile that is normally used on the machine and log into another windows profile, the same table in the same MDB file takes 6 seconds to open. I have tried setting the subdatasheet property to and turning autocorrect off, neither one changes anything. Doing a compact/repair...
2
9839
by: existential.philosophy | last post by:
This is a new problem for me: I have some queries that open very slowly in design view. My benchmark query takes about 20 minutes to open in design view. That same query takes about 20 minutes to open in datasheet view. As an experiment, I deleted all rows in all tables; after that, the query took only seconds to open in both design view and datasheet view. From these facts, I conclude that Access is evaluating the query when I go to...
0
8706
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look ! Part I. Meaning of...
0
9199
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. Here is my compilation command: g++-12 -std=c++20 -Wnarrowing bit_field.cpp Here is the code in...
0
9055
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth. The Art of Business Website Design Your website is...
0
7786
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own.... Now, this would greatly impact the work of software developers. The idea...
1
6550
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms. Adolph will...
0
4391
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
0
4638
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
1
3075
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
3
2016
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...

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.