New to Access security and am wading my way through. Have setup a database and used the security wizard to create some groups and users, assigned rights, etc. Seems to work the way I want so far ...
first q: Using a switchboard to act as the front end menu. Is it possible to use multiple switchboards where depending on the login membership a different menu comes up?
second q: If the above is not possible, can I (on an open form) check the group membership and set buttons visible or invisible depending on the group membership?
Finally, can I create some sort of audit log showing date, time, user name, etc when records are added, deleted or modified in my tables?
TIA -
R. Fisher
first q: Using a switchboard to act as the front end menu. Is it possible to use multiple switchboards where depending on the login membership a different menu comes up?
second q: If the above is not possible, can I (on an open form) check the group membership and set buttons visible or invisible depending on the group membership?
Finally, can I create some sort of audit log showing date, time, user name, etc when records are added, deleted or modified in my tables?
TIA -
R. Fisher