|
security
newsgroups
|
|||||||||||||||||||||||
|
|||||||||||||||||||||||
restrict users from tables but allow access to formsI want to restrict users from updating, input, or delete from the tables and
only allow these functions using forms. Bascially I do not want any users in the tables. I have tried multiple combinations of the user security features but if I allow read only to the table - when the user opens the form and inputs the data and then clicks on the button to run the update query - it fails due to the security setting. If I allow update then the user can open the table and update which I need to prevent. Any suggestions? TIA Cindy You can remove all permissions from the tables, and use run with owner
permission (RWOP) queries for all data interaction. Read about it at www.jmwild.com/RWOP.htm -- Show quoteHide quoteJoan Wild Microsoft Access MVP Thomascl wrote: > I want to restrict users from updating, input, or delete from the > tables and only allow these functions using forms. Bascially I do > not want any users in the tables. I have tried multiple combinations > of the user security features but if I allow read only to the table - > when the user opens the form and inputs the data and then clicks on > the button to run the update query - it fails due to the security > setting. If I allow update then the user can open the table and > update which I need to prevent. > Any suggestions? > TIA > Cindy 
Other interesting topics
Password for CurrentUser()
special permissions on database Adding new users to an Access 2002 DB How to remove Security from Access 2002 Network ID ans user level security logon Failure by Computer accounts in different domain ? Concurrent users - benefits of splitting database MDE security issue Record Level Security How to prohibit users from importing queries from my database |
|||||||||||||||||||||||
