I have tried twice to implement MS Access Security using the wizard, and both times it blew up in my face. What I have is a database that needs the following restrictions applied:
Admin group:
Permissions: Read and Write
Opens into a specific switchboard form (form SB#2)
Access to multiple forms and reports. This is done on the switchboard.
Each user has individual ID and password
Management group:
Permissions: Read Only
Opens into a specific switchboard form (form SB#3)
Restricted to one form only, but multiple reports. This is done on the switchboard.
Each user has individual ID and password
Training group:
Permissions: Read and Write
Opens into a specific switchboard form (form SB#4)
Opens into one form only, but multiple reports. This is done on the switchboard.
Each user has individual ID and password
How can I do this? I can seem to get MS Access security to work. If I could have a VBA type of security logon that then directs individuals to the appropriate area, that would work too.
Any ideas? THANKS
Harry Jessen
HMJessen@Yahoo.com
Admin group:
Permissions: Read and Write
Opens into a specific switchboard form (form SB#2)
Access to multiple forms and reports. This is done on the switchboard.
Each user has individual ID and password
Management group:
Permissions: Read Only
Opens into a specific switchboard form (form SB#3)
Restricted to one form only, but multiple reports. This is done on the switchboard.
Each user has individual ID and password
Training group:
Permissions: Read and Write
Opens into a specific switchboard form (form SB#4)
Opens into one form only, but multiple reports. This is done on the switchboard.
Each user has individual ID and password
How can I do this? I can seem to get MS Access security to work. If I could have a VBA type of security logon that then directs individuals to the appropriate area, that would work too.
Any ideas? THANKS
Harry Jessen
HMJessen@Yahoo.com