MS Access on a Remote Desktop Connection

Posted on 2011-04-20
Last Modified: 2012-05-11
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.
Question by:Andy Brown
    LVL 75

    Accepted Solution

    Briefly ... Microsoft Terminal Services.
    I have one client with your paradigm ... and TS works VERY well.

    Check the Microsoft website for details ...
    LVL 22

    Assisted Solution

    by:Nico Bontenbal
    If you don't want to buy your own hardware (yet) you could go for:
    or (if you can do the setup yourself)

    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.
    LVL 56

    Assisted Solution

    by:Jim Dettman (Microsoft MVP/ EE MVE)
    The TS setup works well.  Another approach is a service from this company:

      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.

    LVL 26

    Assisted Solution

    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.

    Author Closing Comment

    by:Andy Brown
    Thanks guys - that's really useful info.

    Featured Post

    6 Surprising Benefits of Threat Intelligence

    All sorts of threat intelligence is available on the web. Intelligence you can learn from, and use to anticipate and prepare for future attacks.

    Join & Write a Comment

    Introduction When developing Access applications, often we need to know whether an object exists.  This article presents a quick and reliable routine to determine if an object exists without that object being opened. If you wanted to inspect/ite…
    Introduction The Visual Basic for Applications (VBA) language is at the heart of every application that you write. It is your key to taking Access beyond the world of wizards into a world where anything is possible. This article introduces you to…
    Familiarize people with the process of utilizing SQL Server functions from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Ac…
    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…

    729 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

    Need Help in Real-Time?

    Connect with top rated Experts

    18 Experts available now in Live!

    Get 1:1 Help Now