Solved

MS Access Database slow to search database remotely

Posted on 2009-07-16
5
283 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
[X]
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
5 Comments
 
LVL 50

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 50

Assisted Solution

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

/gustav
0

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

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

It’s been over a month into 2017, and there is already a sophisticated Gmail phishing email making it rounds. New techniques and tactics, have given hackers a way to authentically impersonate your contacts.How it Works The attack works by targeti…
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…
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …

740 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