An existing MS Access 2003 project frontend with a MS Sql Server 2005 backend needs to be accessed from different locations (not just one LAN anymore). Instead of implementing a VPN, we are thinking about moving the SQL Server as well as the MS Access project to a Windows 2008 terminal-server (hosting outsourced).
Will it be possible for 20 users to access this server by RDP an run their individual instancea of MS Access without interference with the other users' instances? Would that be a good solution?
Short answer: Yes, that will work.
Not only can each user run their own instance of Access, they can each run multiple instances. Assuming of course that there are no limits on the backend SQL Server (I don't use it, so I don't know). I do the same thing here using Access as a front end to MySQL databases.