speed up access to database from low bandwidth site

I have an access database being accessed from a remote site that has a 8mb bandwidth.  It is painfully slow to the point of being unusable.  I used to use replicated databases with Access 2003 but that is no longer available with Access 2010.  Does anyone have any suggestions?  Would a terminal server connection to the database help?
LVL 1
ksilvosoAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Lee W, MVPTechnology and Business Process AdvisorCommented:
Terminal Server is the route I'd recommend... unless you want to upsize it to a SQL database, but even that could be slow.
0
Gustav BrockCIOCommented:
Yes, it would even be a perfect solution at little cost (or none if a simple remote desktop connection to a workstation will do) and with a predictable success and about zero time for implementation.

/gustav
0
Scott CSenior EngineerCommented:
A TS connection should help as the only thing going over the wire is the images from the screen and not the actual data or calculations.

Another option of course is to get a faster connection to the other site but if that isn't possible or feasible, the TS or Citrix would be a good solution.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

Scott CSenior EngineerCommented:
LOL !!!  3 answers that are the same in 30 seconds.  I'd say you have your answer.
0
JohnBusiness Consultant (Owner)Commented:
I use a desktop computer with QuickBooks installed, VPN into the client, run RDP and access the desktop computer and then run QuickBooks at the clients computer. This works fine, and is an mini Terminal Server setup at very low cost.
0
Dale FyeCommented:
Just out of interest, how is your application currently connected to the back-end?

Is the back-end on a network server on your LAN or on a WAN;  sounds like a WAN?

Are you using linked tables, or are you exclusively using ADO to get at your data.

What kind of connection do you have that is limited to 8Mb bandwidth?
0
ksilvosoAuthor Commented:
Wow, thanks for all the responses.  Needless to say I'm leaning toward Terminal Server.  In answer to the previous comment, the back end is simply another access database containing tables only.  But that needs to stay put to serve a majority of users in this area.  I guess you'd call us a WAN.  Most of our sites are located in one city but this particular site is in another city
0
John TsioumprisSoftware & Systems EngineerCommented:
Unless you have planned carefully your back end (SQL) to fetch only the bare minimum am afraid that TS is the only solution....
0
Dale FyeCommented:
Access FE to Access BE will not generally work over a WAN, unless you have an extremely wide bandwidth.  You can mitigate this some by using ADO to connnect to your backend and pull recordsets across the network, but even that will be extremely slow, and will require significant rewrite of your application.
0
aikimarkCommented:
You might create a web service to execute the query on the server and return the selected records.  Most any form of a database-wrapping (server-proccessed SQL) scenario would do.  Moreover, you could even compress the results if you found that you are capacity limited by WAN speed.
0
ksilvosoAuthor Commented:
Thanks for your help.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Access

From novice to tech pro — start learning today.

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.