Access program running slow on certain computers only

Posted on 2014-12-02
Medium Priority
Last Modified: 2014-12-04
Hello All,

I have an Access 2010 program that sits on a 2008 server.  Many people use the program and the way it is currently set up is that each person has a shortcut to the program (They fight me on splitting the front end from the back end).  On certain computers the program runs really really slow, to the point of screens freezing or the background of Access popping forward.

What is odd is that I remote into a computer in building 1 and from there I open the shortcut to the program.  For me it runs nicely.  The people who are having the problem with speed are in building 2.  The reason I find it odd is that I would think my computer would be the slow one since I am remoting in from my computer at home and from that computer I am accessing the program.

I did a tracert on a bunch of computers and any computer from building 1 (including the one I remote into) show <1ms while machines in building 2 show 1 to 2ms.  Could that be that much of a difference?  

Is there something I could do or run to check on the network between the two buildings (which are next to each other, not miles down the road)?

Networking is not my strongest suit so I am willing to try almost anything to get the people in building 2 faster access.


PS It does not matter how many people are actually using the Access program at the time.  It has slowed down even with 2 people on it.
Question by:alevin16
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
LVL 26

Expert Comment

ID: 40476890
They fight me on splitting the front end from the back end
You really need to win that fight.
You're one corruption away from losing the DATA and the UI
When split, the data never winds up being corrupt, and the front end gets pushed to many workstations, so there is rarely ever the danger you will forever lose the front end or any data.

Could that be that much of a difference?
Are both building on the same subnet?
Networking is not my strongest suit
Do you know how to determine that?

If they AREN'T on the same subnet, what device is doing the routing?
LVL 38

Expert Comment

ID: 40476940
I agree 100% with Nick.  Having a monolithic database is a problem waiting to happen but it isn't causing this problem.  

I would suggest posting in a network forum where people will give you the words you need to convince your network person that he has to look into the problem.

PS - once you get the app split, make sure that each user has his own personal copy of the FE.  You don't want everyone opening the same physical copy of the FE.  There are lots of simple ways of distributing the FE.  The easiest of which is to have each user run a batch file to activate the app rather than running the app itself.  The batch file copies the latest version of the FE from the safe network folder to their local C: drive and then opens it.  On most networks, the delay is imperceptible.
LVL 26

Expert Comment

ID: 40476994
How is performance in file transfer.
Can you COPY the database between the server and the workstations in both buildings with equal speed.
Or is one markedly slower than the other?
How are they connected?
Migrating Your Company's PCs

To keep pace with competitors, businesses must keep employees productive, and that means providing them with the latest technology. This document provides the tips and tricks you need to help you migrate an outdated PC fleet to new desktops, laptops, and tablets.

LVL 85
ID: 40477483
And just to pile on: I agree 100% with both Pat and Nick regarding splitting. You may find yourself in a very bad way if you don't. There's really no good reason to NOT split the database, other than to make updates easier (and with a decent updater, that's not really an issue).

Also: I had a client with a very similar issue - two buildings, and the users in one building were perfectly fine whereas the users in the second building had quite a bit of intermittent issues. Turned out to be some very old wiring and hardware. Rather than trying to update all that, they just setup a Terminal Server and ran everyone off that. Worked well, but of course there was some cost involved.

Author Comment

ID: 40477693
Hello Everyone,

Thank you so much for all the feedback and information.  To answer one of the questions both buildings are on the same subnet, not sure about the wiring, but I do know it is not wireless.

Believe me I have tried to convince them to allow me to split the DB but for some reason they see this as evil.  I will try again with your comments in hand.

One other thing to throw into this discussion, I ran LAN Speed Test (Lite) from Totusoft on a computer in both buildings (I remoted into them).  Here are the numbers.  I do not know if the difference is significant (being that 1 ms vs. 2 ms seems really really small):

Machine in the “fast” building      Write                  Read
Time to Complete                           1.0162716              1.6824556
Bytes per second                          19,679,779        11,887,387
Bits per second                         157,448,232      95,099,096
Machine in the “slow” building      Write                  Read
Time to Complete                        2.3950350      2.5154914
Bytes per second                        8,350,608      7,950,733
Bits per second                            66,804,864      63,605,864
LVL 10

Assisted Solution

by:Luke Chung
Luke Chung earned 400 total points
ID: 40478602
LVL 26

Expert Comment

ID: 40478832
I don't know much about the tool you used but look at the results: 1.0162716 vs 2.3950350
Or 2.35 times as long to complete the same task on the slow side compared to the fast side.
That's likely to be highly significant.

As a test, move the db to a machine on the slow side.
Test from another machine on the slow side
Are things greatly improved?
Test from another machine on the fast side
Are things greatly degraded?

If they are, then you have your answer -- your network architecture is killing performance.
If not, we'll keep experimenting

Author Comment

ID: 40478966
That is a great idea Nick, I am going to give it a try

Author Comment

ID: 40481610
I spoke to the person in charge of the network for this issue emailed me this:

Alot of this has to do with distance more than anything else, "Fast" computer is going about 10 ft to the server vs "SLow" computer is going 35-40 ft to the switch in that building, then via fiber 100 ft -/+ to the switch in the server room. There will be some lag time.

Do you all think that this could explain the slowness of the slow machines?  I tested the speed again and the fast machine actually came in 10 times faster.  If this is the case what could we do to speed up the "slow" connection?

THank You!
LVL 26

Accepted Solution

Nick67 earned 1600 total points
ID: 40481807
A lot of this has to do with distance more than anything else
Any network guy who would tell you this is:
a) BS'ing
b) incompetent

Fibre moves at lightspeed
Electrons in copper about 2/3 lightspeed.

"Fast" computer is going about 10 ft to the server
99/100 the fast computers and server are on the same switch
SLow" computer is going 35-40 ft to the switch in that building, then via fiber 100 ft -/+ to the switch in the server room
And ALL the traffic from the other building needs to use that fibre.

So 'fast' machines get a 1:1 channel to the server, slow machines get 1:HoweverManyConnection to the server.  That can be bad.

The switches could be old POS (and I don't mean point of sale)
The fibre installation could be old and inefficient.
If the server is old, it could be a 100 MB card in the server
How many machines in total?

If this is really a rock-in-the-boot, then document things and kick it up to management to have the link sorted, replaced, and/or upgraded.

In order of expense
1. Add a second network card to the server and configure the network so that the slow building's traffic goes to that network card first, and not to the switch (make the server route).  May not solve the issue, though
2. Replace the switches.  If one or both are POS's things may improve
3. Replace the switches and fibre modules with better/higher speed.  More expense, likely to solve the issue
4.  Go hard and get someone in to look at the whole setup.

Author Comment

ID: 40482085
Hello Nick67,

This is exactly what I was looking for.  Someone who could explain what is going on in easy terms.  Thank you so much!  I am going to discuss this with the network guy and see what we can do.  if he won't budge I am going higher.

LVL 26

Expert Comment

ID: 40482100
Good Luck!
You may not want to show him
A lot of this has to do with distance more than anything else
 Any network guy who would tell you this is:
 a) BS'ing
 b) incompetent

But anyone trying to insist that distance is the issue...well.
Ethernet copper has a distance limit of 93 metres from switching device to switching device (typically switch to switch or computer to switch)  That limit comes because the amount of time that a network device waits before deciding that it's packet is lost is exceeded by the travel time it takes to get to the far end.

A typical packet is ~1500 bits.
Gigabit Ethernet 1073741824 bits per second
715827.8827 packets per second.  And a packet can't make 93 metres without maybe being lost.
But we can blow 715828 of them down 92 metres of line each second.
So --rough numbers because ACKs come back on the line -- a packet takes 1/715827 of a second to travel 92 metres or less. ~66 million meters per second.

At that speed, 40 feet is going to result in how much delay?

Featured Post

Get MySQL database support online, now!

At Percona’s web store you can order your MySQL database support needs in minutes. No hassles, no fuss, just pick and click. Pay online with a credit card.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Access custom database properties are useful for storing miscellaneous bits of information in a format that persists through database closing and reopening.  This article shows how to create and use them.
Did you know that more than 4 billion data records have been recorded as lost or stolen since 2013? It was a staggering number brought to our attention during last week’s ManageEngine webinar, where attendees received a comprehensive look at the ma…
Do you want to know how to make a graph with Microsoft Access? First, create a query with the data for the chart. Then make a blank form and add a chart control. This video also shows how to change what data is displayed on the graph as well as form…
Visualize your data even better in Access queries. Given a date and a value, this lesson shows how to compare that value with the previous value, calculate the difference, and display a circle if the value is the same, an up triangle if it increased…
Suggested Courses
Course of the Month14 days, 11 hours left to enroll

771 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question