Recently began to learn the Access, imitate the case made a own small database, there are a few questions I hope you who can help me answer the one is how to set up different permissions to different users? I have a users table, but I didn't find a place to set the permissions,
Second, no matter what the navigation pane on the left side of the database will be able to own switch by using the method of set, so even if through the login form to different user permissions, the user can directly through the navigation pane into other forms or table, bypass the login form, so don't login is meaningless?
3 it is if you want to put the database on the local area network (LAN) website, must through the web compatibility analysis and use access services? What other method?
Thank you all for the great god

CodePudding user response:

Permissions is generally used to restrict the user, the user USES a database, shall be conducted only by the form, therefore, set permissions, is actually to different users, control forms, controls are not available, or is not hidden,

Therefore, you need to design the user table, targeted permissions list, even form the table, the control table, and then by VBA limits on the forms,

ACCESS interface of itself, can be hidden by VBA, however, the ACCESS there is still a way to bypass the hide,