MS Access latency across distance

The_Kurgan

The_Kurgan

Active Member
Joined
Jan 10, 2006
Messages
270
I have an Access DB on a local drive that runs fine for me, but slowly for people in other parts of the country. If I place it on their server, it runs fine for them, but slowly for me.

Is there a way around this lag issue? I tried splitting the DB and giving them the front-end, but that only mildly enhanced efficiency.

Any suggestions would be greatly appreciated!
 

Excel Facts

Create a Pivot Table on a Map
If your data has zip codes, postal codes, or city names, select the data and use Insert, 3D Map. (Found to right of chart icons).
Sort by date Sort by votes
I think you both need to read this by MVP Albert D. Kallal. Access is NOT good for running across a WAN and if you aren't using a split database you run a BIG risk of losing all of your data AND the rest of your database as well.
 
Upvote 0
The_Kurgan said:
I have an Access DB on a local drive that runs fine for me, but slowly for people in other parts of the country. If I place it on their server, it runs fine for them, but slowly for me.

Is there a way around this lag issue? I tried splitting the DB and giving them the front-end, but that only mildly enhanced efficiency.

Any suggestions would be greatly appreciated!
Click to expand...
I solved a problem like this a few years ago with a cheap (well fairly cheap) and cheerful solution where we put a spare machine in the same office as the server and then used PCAnywhere from a remote location to access that machine and run MSAccess on it. It worked well for a few years before it was replaced with an SQL Server solution.
Hope this helps
 
Upvote 0
You must log in or register to reply here.

Similar threads

O
  • Solved
Questions about usage of SQL Server as Back end and MS Access as Front End
Replies
7
Views
9K
ODSCm
O
CPGDeveloper
  • Question Question
Constant Back End Corruption
Replies
3
Views
3K
stumac
S
CPGDeveloper
  • Question Question
Maintenance of MS Access Back End
Replies
8
Views
3K
Micron
M
J
  • Question Question
Power Query editor OR VBA to extract data from Grants.gov
Replies
3
Views
377
Jagadeshrao
J
CPGDeveloper
  • Question Question
Access DB Randomly Shutting Down
Replies
1
Views
1K
Joe4
Joe4

Forum statistics

Threads
1,224,616
Messages
6,179,912
Members
452,949
Latest member
beartooth91

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top