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?