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?
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

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).

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
slimguyAuthor Commented:
Your comments have given me some good clues as to the source of the problem. Thank you.
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Access

From novice to tech pro — start learning today.