Permissions being erased davecoats622 23.02.2006 15:56:30 I have a database with a front end and backend where I have set permissions on objects on the Group level (not user level). My general users group is called "CRTP". All table objects in this group have "Read Design", "Read Data", "Update Data", "Insert Data", and "Delete Data" permissions. When a user starts using the application, they get a message that says they do not have rights. Then when I go back into the security wizard, I find several tables where all the permissions have been removed. Why does Access automatically remove permissions after I've already assigned them? Is there some kind of dependency to another object which causes them to be erased?

Re: Permissions being erased "Joan Wild" <jwild[ at ]nospamtyenet.com> 23.02.2006 17:03:04 Where are you setting the permissions? i.e. Check in both the frontend and the backend. I generally don't give users any permissions on tables, but instead use RWOP (run with owner permissions) queries for all data interaction. -- Joan Wild Microsoft Access MVP davecoats622 wrote: [Quoted Text] > I have a database with a front end and backend where I have set > permissions on objects on the Group level (not user level). My > general users group is called "CRTP". All table objects in this > group have "Read Design", "Read Data", "Update Data", "Insert Data", > and "Delete Data" permissions. When a user starts using the > application, they get a message that says they do not have rights. > Then when I go back into the security wizard, I find several tables > where all the permissions have been removed. Why does Access > automatically remove permissions after I've already assigned them? > Is there some kind of dependency to another object which causes them > to be erased?