I have an Access 2007 database on a server to which various users remote to. The database is separated in three sections, the front end which is copied on each user's profile, the backend containing the tables accessible to all and the secured database containing only the tables that have a limited access.
The secured tables have been put in a folder on the network to which I gave full access to the appropriate users and read only to the others. When I tested over the weekend the security worked fine, the users with full access can make any required changed and the others can view the tables but not change anything.
However, this morning the issue is that when users that do not have full access try to access the secured tables they are only accessible to one user at a time
How can I resolve this issue