?
Solved

MS Access Database slow to search database remotely

Posted on 2009-07-16
5
Medium Priority
?
290 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 53

Accepted Solution

by:
Gustav Brock earned 1732 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 136 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 132 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 53

Assisted Solution

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

/gustav
0

Featured Post

Get 10% Off Your First Squarespace Website

Ready to showcase your work, publish content or promote your business online? With Squarespace’s award-winning templates and 24/7 customer service, getting started is simple. Head to Squarespace.com and use offer code ‘EXPERTS’ to get 10% off your first purchase.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

If you need to implement application level security in an Access database application or other VBA code, I strongly encourage you to take advantage of Active Directory groups.
With the functions here, you can parse, convert, and format back and forth between feet and inches and fractions and decimal inches - for normal as well as extreme values and with extreme precision.
Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…
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…

589 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