How do I Allow Multiple Terminal Server users access to an Access Front End?
Hello! I've been configuring a Terminal Server for the last little while, and I've come across an issue that I thought I'd bring up with you guys.
The Terminal Server is Windows Server 2003 R2, and I'm configuring the Terminal Server because I'd like to have multiple users access a Microsoft Access front end database application that talks to a SQL server on the network. At the moment, each user has the database front end in their local C drive, and they just launch the front end which acts as a client, to access the data on the server. Now, with the new setup, I'd like each user to be able to log into the Terminal Server and to only be able to run Microsoft Access and that database front end file.
Here's what I did. I moved a copy of the front end Microsoft Access file they use onto the Terminal Server, placed the Access front end in the root of C, gave authenticated users modify permissions on the folder, and then tried logging in as 2 or 3 test terminal server users. You may figure out pretty fast if you're familiar with Access that the first account that opened the access database worked, and subsequent accounts couldn't open the database because of the database lock. My question is, can each Terminal Server user share one front end database file? Or do I have to update a front end database on each users configuration each time there's an update to the front end? I'd end up having something like C:\Documents and Settings\Username\Database\FrontEnd?? Then I'd have to log in and replace the files in each \Database\FrontEnd folder of each Terminal Server user on each update of the application [which doesn't happen often, maybe every 2 to 3 months we receive an updated front end].
Thanks for any information!