I am currently setting up some client PCs for my office. All the users are set up as a restricted user within XP. I have Access 97 on the machine to access some databases that were created years ago. The restricted user can open Database1 with no problems. However, with Database1 open, when they try to also open Database2 at the same time, they receive the following error: "Couldn't use c:\windows\system32\system.mdw, file already in use." However, if I change the XP user permissions to set them up as an Administrator, they can open both databases at the same time with no problem.
Any thoughts on how I can keep them as a restricted user within XP and still allow them to open two databases at the same time?