InfoPath and Access DB Security

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!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top