Question Access 97 Security

[gregoryagu]

I have a client with an Access 97 database with about 50 people using it. When I update the security of objects, it appears that the changes made to the System.mdw file don't take effect until after everyone exits the system. Is this correct?

The reason I ask is that it seems that the security changes that are made to new reports and whatnot do not seem to take effect right away. In other words, I will add a new report to the system. I then go in and assign the appropriate security permissions. I then log in as a user, and access is denied even though I just set the permissions. Then a few days later, someone will tell me that they can go into it ok even though I didn't make any other changes to security.

I am just trying to figure out what is going on with the permissions not updating correctly. I have checked and double checked that the correct mdw file is being edited.

Thanks,

Greg

 

[gregoryagu]

OK, I finally figured this out.

This is a split database, and table permissions needs to be set on both the Front End Database, as well as the back end. I was setting permissons on the Front End without setting the backend, and Access uses the MOST restrictive permissions in this case.

Case closed.

Greg

 

[kjyoung]

super helpful, thanks.