i have just installed Microsoft office onto my terminal server. What is want is for them to use our database and when it comes to exporting it to excel spreadsheet to look at the data, i want them to be able to save it on there Pc and not mine.
Currently i have setup a win 2003 server running terminal server. This is no every now and again they can access our database to look up parts etc. When they want to export this to excel it shows the terminal server drives and not any of the drives they have on there network or PC. I would like the option for them to choose eg j: which is located on there server.
If this cant be done is there are way of locking there access to a complete drive rather just than files and folders. I dont want them to see or touch anything that is on my side of the server?