Securing selected forms with a password.

F

Frank Martin

I have a small database in Access2003 and I
need to know how to secure some tables,
queries and forms with a password.

Please help, Frank
 
R

Rick Brandt

Frank said:
I have a small database in Access2003 and I
need to know how to secure some tables,
queries and forms with a password.

Please help, Frank
Click to expand...


Do you want "security against the malicious" or "guidance for the cooperative".

Only by setting up full blown user level security (advanced topic) can you come
anywhere close to the former (and that is just coming close). Putting passwords
into the Open event of certain forms clearly falls into the latter category and
that is only possoible with forms, not with tables or queries.

In the latter category there are a handful of obfuscation techniques that are
easy, painless, and at least force "snoops" to be fairly familiar with Access.

So, what sort of "blockage" did you have in mind?
 
F

Frank Martin

in message
Do you want "security against the
malicious" or "guidance for the
cooperative".

Only by setting up full blown user level
security (advanced topic) can you come
anywhere close to the former (and that is
just coming close). Putting passwords into
the Open event of certain forms clearly
falls into the latter category and that is
only possoible with forms, not with tables
or queries.

In the latter category there are a handful
of obfuscation techniques that are easy,
painless, and at least force "snoops" to be
fairly familiar with Access.

So, what sort of "blockage" did you have in
mind?
Click to expand...

My family has access to the computer and I
want to keep the kids away from the forms.
Regards.
 
Top