I have a created a Billing system for a school with MS Access 2007 and would like a incorporate a login system to prevent unauthorised access in to the database. This system must have Administrator and user privileges and must allow both the Administrator and users to modify username and password. Again, only the Administrator is subjected to modifying the database itself. This system should be a multi-user type. In short, just like what is Ms Access 2003. I don't know how to do this please help.
-
-
Take a look on this website as a reference, at least it can show you how to create login stuffs.
The privileges are simply require additional column on user groups you defined. Then it'll be up to you on how the database checks user privilege with the user groups; and how the database should act among these results.
Comment