Solved

MS Access Database slow to search database remotely

Posted on 2009-07-16
5
279 Views
Last Modified: 2012-05-07
I have 40mb access database that I have on my local lan.  I am able to do a search on it and get a result immediately.  

When my colleagues in another building try to do the same, their search will take 5 minutes to get a result or the client will hang.  They are connected to us via  a 2 MB MPLS link and when I tested there was 1.8mb free bandwidth.

I ran a ping -t from the client machine to the server where the database sits and noticed that while the search was running  the ping results changed from 1ms to 100ms erratically. As soon as I killed off MS Access, the client machine sat at a permanent 3ms.

I have done the usual stuff and compacted database etc, but still no joy.

Any ideas where I could start looking
0
Comment
Question by:PCGB
5 Comments
 
LVL 49

Accepted Solution

by:
Gustav Brock earned 433 total points
ID: 24869081
This "can't" be done. Access (JET) requires a normal LAN connection running at normal speed (10 Mbps+).

/gustav
0
 
LVL 27

Assisted Solution

by:MikeToole
MikeToole earned 34 total points
ID: 24869197
What is the client you're using?
The probable problem is the amount of data going down the wire. An Access database is a File server rather than a database engine - a query in the client can result in the need to tranfer the entirety of a table to the client for processing, depending on the criteria in the query and the indexes on the table.
Can you give an idea of your table structure and  sample request that causes the problem?
0
 
LVL 39

Assisted Solution

by:thenelson
thenelson earned 33 total points
ID: 24869235
A way to do this remotely over the slow connection is have Access run in a computer on the local lan and use remote desktop over the MPLS link. This way all Access processing will be over the local lan and only keyboard and display will transfer over the MPLS link.  The remote terminal will become a dumb terminal.
0
 

Author Comment

by:PCGB
ID: 24869253
Thanks for all your answers.  I have decided to move the database over to their local server as no one here needs access to it.
 
 
0
 
LVL 49

Assisted Solution

by:Gustav Brock
Gustav Brock earned 433 total points
ID: 24869464
Some problems dissolve by themselves ...

/gustav
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

Microsoft Office Picture Manager was included in Office 2003, 2007, and 2010, but not in Office 2013. Users had hopes that it would be in Office 2016/Office 365, but it is not. Fortunately, the same zero-cost technique that works to install it with …
No matter the version of Windows you are using, you may have some problems with Windows Search running too slow or possibly not running at all. Before jumping into how you can solve this issue, just know there are many other viable alternative deskt…
What’s inside an Access Desktop Database. Will look at the basic interface, Navigation Pane (Database Container), Tables, Queries, Forms, Report, Macro’s, and VBA code.
The viewer will learn how to create a normally distributed random variable in Excel, use a normal distribution to simulate the return on an investment over a period of years, Create a Monte Carlo simulation using a normal random variable, and calcul…

920 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

Need Help in Real-Time?

Connect with top rated Experts

17 Experts available now in Live!

Get 1:1 Help Now