• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 268
  • Last Modified:

Terminal Services directory ownership

I have an Access database in a directory on the C drive on a server (2008). If I login over Remote Desktop Connection with User1, I can open the database and see and amend the data. If I login to (apparently) the same database in the same directory with User2, the data is different. Although the database filename and directory is appartently identical, they must be different physical files. How can this be? I am very confused.
Can each user see their own set of cloned files in some virtual PC?
How can a database file be created that is shared by ALL users?
1 Solution
Scott McDaniel (Microsoft Access MVP - EE MVE )Infotrakker SoftwareCommented:
You need to make sure the database is stored somewhere that ALL TS users can access, whether that is on the TS box itself or on another networked resource. You also need to insure that all TS users have at least Modify permissions on that folder (note the term "TS Users", which is generally a group defined on the server specifically for remote users).

Note also that 2008 makes use of virtualization, which means the folders you "see" when opening My Computer and such are not the physical representations of the location, but rather the "virtual" locations. I'm not 100% sure where all those are stored physically, but you should be storing your data in the "Public\Data" portion of the Documents library (assuming 2008 mimics the folder structure and usage of Vista and Win7, that is).
slimguyAuthor Commented:
Your comments have given me some good clues as to the source of the problem. Thank you.

Featured Post

The 14th Annual Expert Award Winners

The results are in! Meet the top members of our 2017 Expert Awards. Congratulations to all who qualified!

Tackle projects and never again get stuck behind a technical roadblock.
Join Now