Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

I need to give 50+ users access to their own copy of Access DB via RDWeb (previously TS). I do not want to have to create 50+ icons and dish them out onto the RDWeb interface if at all possible. Is there a way to set them all up and only give them access to their own DB. They can see just not access each others. Also I am having an issue where Access will not open a DB if it is not a trusted file or in a trusted location. This is complicated by having to create a trusted location for each user. I would like to use an all inclusive link for all users. I apologize if I am asking for too many things at once, but I've been racking my brain and using "Google college" to try and resolve this.

This is all related and one question.

share|improve this question
1  
Split your question up into multiple questions, please. Just edit this one, remove one, and then open a new question. –  Evan Anderson Jul 17 '12 at 17:54
add comment

1 Answer

Can you map the location to a mapped network drive using their username? Basically something like net use x: \server\users\%USERNAME%. Then drop the users copy in their individual folder. resolve the trust issues for the files and you should be set. Then you can map a shortcut to x:\.

share|improve this answer
    
I have tried this and it will not work as we are running everything through an RDWeb interface it errors out on error 55. It will almost work with a string like COM1: x:\server\users\%username% but gives an error 53 after inputting username and password. RDWeb is a difficult tool to use. –  Jason Willis Jul 17 '12 at 21:56
    
Yeah, I can't help with the RDWeb stuff as I am not familiar with it. I was hoping it was similiar to Terminal Services where each logged in user get a local profile and it can execute scripts as needed. Might be able to script something to do what you are asking. maybe execute a script that fetches a copy from the local machine somewhere to a temp storage location by user and then throws it away when its done with it? (i assume the data the users need isn't in Access itself and its pulling from some other source like SQL) –  MikeAWood Jul 17 '12 at 22:04
    
You are correct on all aspects of your reply. It did use to be TS, but we all know how MS likes to tinker with all the stuff that works when they change\upgrade something. I've found many forums stating the same stuff about TS but MS broke all of that so they could name it something else and have yet to update their KB's. It is not pulling from Access necessarily it just needs somewhere to have DB's located that is trusted, kinda like having a program installed and moving the .exe from the install folder and it not running since it can't find the required files\folders it needs. –  Jason Willis Jul 17 '12 at 22:45
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.