I have a strange problem. The company I work for has an engineering drawing database that has 20 or so users that have Read Only access. There's only 1 user account in our AD system that has write access, and all those other 20 users have to go through someone to add changes to the database, which uses the "final" account to add.
If one of the read only accounts opens the database, of course it does what it is supposed to do...opens the drawing read only . When they open the database it pops up and lets them know, it's read only. While they have the file opened, if the "final" user (with full control) opens the database, THEY now only have read only rights. It says so at the top of Access, and they cannot make changes to the database.
This is not what we need of course, and I am at your mercy :)
Thanks in advance!