R
ridawg
Hey,
I need to build a database that will be used to track employees that are
allowed to purchase items and their authority levels as far as purchasing.
My plan is to create an Access database to store the info and an InfoPath
form to allow the appropriate users to add, update, and delete info. I also
have a set of users that need to have access to the form to just view info.
I believe using Roles within my InfoPath form I can create an admin role
(can add, edit, & delete) and a viewer role (just view).
What I'm not clear on is how to protect the database. I need to make sure
only myself and those in the admin group have access to the database. It's my
understanding in order for my form to work I need to give all user of the
form read/write access to the database. Something to do with the way Access
works - I guess it needs to create a temp.ldb file when a user accesses the
database.
Just looking for some help/guidance on how to set up security so the form
works but only the admin people have access to the database.
Thanks!
I need to build a database that will be used to track employees that are
allowed to purchase items and their authority levels as far as purchasing.
My plan is to create an Access database to store the info and an InfoPath
form to allow the appropriate users to add, update, and delete info. I also
have a set of users that need to have access to the form to just view info.
I believe using Roles within my InfoPath form I can create an admin role
(can add, edit, & delete) and a viewer role (just view).
What I'm not clear on is how to protect the database. I need to make sure
only myself and those in the admin group have access to the database. It's my
understanding in order for my form to work I need to give all user of the
form read/write access to the database. Something to do with the way Access
works - I guess it needs to create a temp.ldb file when a user accesses the
database.
Just looking for some help/guidance on how to set up security so the form
works but only the admin people have access to the database.
Thanks!