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.