Hello,
This might seem like a basic query, but I am trying to add some security on a individual Access front end that links to a SQL back-end. At the moment, it is accessible via a single password on the file, but we would like to add a 'read-only' account. I have set up user permissions on the front end that has a separate admin under the owner's name, and a 'user' account which has access to the file, but cannot change any data.
The front end lies in a shared area, and it works fine from the account it has been setup on. However, if I logon to a different user on a different PC and open the file from the shared area, the security has disappeared (despite the fact that the mdw file is in exactly the same shared folder). How do we get the security that was setup to propagate to all users? Am I missing something really obvious?