Passwords on Forms

[Guest]

Does anyone know if there is a way to password protect a form? The reason is
because Management will need to pull up the form in order to assign work but
they don't want anyone else that uses the database to be able to see who the
work was assigned to.

 

[Rick Brandt]

Does anyone know if there is a way to password protect a form? The
reason is because Management will need to pull up the form in order
to assign work but they don't want anyone else that uses the database
to be able to see who the work was assigned to.

If you password protect the form what is to prevent someone from looking
directly at the table? What you would need id to apply User Level Security (an
advanced topic) and even that is easily hacked by someone willing to do a little
research.

Bottom line: if you need to protect data from non-users use network security to
limit access to the file. If you need to protect data from users then don't
store it in an MDB file. Use a server database with more robust security.

 

[Bill Mosca, MS Access MVP]

A simple way to do it without using user level security is demonstrated at:
http://support.microsoft.com/?id=209871