• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 341
  • Last Modified:

MS Access on a Remote Desktop Connection

I have a client that uses one of our Access database apps.  To date this has been run across a local network, but they now want remote users (as well as local) users to be able to access it.  They won't want to spend a fortune, but they do understand that they will need to purchase a server and some software.

Could anyone point me in the right direction as to a decent, reliable solutions.

PS - There could be up to 20 people logged in at any one time.
0
Andy Brown
Asked:
Andy Brown
4 Solutions
 
DatabaseMX (Joe Anderson - Microsoft MVP, Access and Data Platform)Commented:
Briefly ... Microsoft Terminal Services.
I have one client with your paradigm ... and TS works VERY well.

Check the Microsoft website for details ...

zzzzzz.mx
0
 
Nico BontenbalCommented:
If you don't want to buy your own hardware (yet) you could go for:
http://www.infinitelyvirtual.com/categories/office-virtualization.html
or (if you can do the setup yourself)
http://aws.amazon.com/ec2/

When you buy your own server with Windows 2008 Server you can set it up as a Terminal Server allowing multiple users to connect tot he machine through remote desktop. I advise you to ask a SysAdmin to do the setup.
0
 
Jim Dettman (Microsoft MVP/ EE MVE)PresidentCommented:
The TS setup works well.  Another approach is a service from this company:

www.eqldata.com

  They have been a around a few years now, but I still have not heard of anyone using their service and if it works as advertised.

  Also, in regards to TS, you may want to put Citrix on top of that.  Citrix uses it's own transfer protocol which is more efficent then RDP and handles disk and printer mapping better.

  I have one client where we use Citrix Access Essentials and it allows remote users to connect through a web browser without a VPN to the TS server.

JimD.
0
 
Nick67Commented:
The biggest issue is the definition of <remote users>.
If everybody is on a decent wired connection the out-of-the-box RemoteApp solution in Server 2008 works very well.

If you have users on 3G or 3G+ cellular networks, latency becomes a big issue.
Whether it's RDP or Citirx you are passing mouse and keyboard one way and video the other.
There isn't a lot of data--but if it has to go slow hop after slow hop through a cellular network, the end experience isn't great.
0
 
Andy BrownAuthor Commented:
Thanks guys - that's really useful info.
0

Featured Post

Upgrade your Question Security!

Add Premium security features to your question to ensure its privacy or anonymity. Learn more about your ability to control Question Security today.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now