Securing portions of a table or form

[Guest]

I am learned about ULS and have applied that to my database for the good it
will do in an honost (I hope company). My question is can you secure
(password protect) certain cells (collumns) in a table or lock certain cells
on a form that only someone that signed in with a givin password could fill
in the block. I have a form that requires signatures and if I could show
that only the person with the proper password could fill his name in, then
this would be a valid form.

Any help is greatly appreciated

 

[Rick B]

This is asked and answered pretty often.

What you would do is write code that looks at the userid or the groups to
which they belong. The code would lock fields if they are not in a group
that can change them, and unlock them if they can.

You may want to just build two forms and give access to one for people who
can make the changes and give access to the other for folks who can't make
the change.

 

[Lynn Trapp]

Take a look in the Security FAQ regarding RWOP queries. You can find a link
to the FAQ on the Security page of my website.

--
Lynn Trapp
MS Access MVP
www.ltcomputerdesigns.com
Access Security: www.ltcomputerdesigns.com/Security.htm
Jeff Conrad's Access Junkie List:
http://home.bendbroadband.com/conradsystems/accessjunkie.html

 

[Guest]

Ok - but does that apply only to Queries? Should I work it that way? I am
trying to capture signatures for approval purposes. The FAQ mentioned
security for tables but talked only about Queries. Is there somewhere else
to go for more informations.

I am real new at all this and may be in over my head but I like my system
and just want it to be even more usable.

Thanks

 

[Lynn Trapp]

Ok - but does that apply only to Queries? Should I work it that way? I

am
trying to capture signatures for approval purposes. The FAQ mentioned
security for tables but talked only about Queries. Is there somewhere
else
to go for more informations.

Yes, it applies to queries only and, yes again, you should definitely work
that way.

--
Lynn Trapp
MS Access MVP
www.ltcomputerdesigns.com
Access Security: www.ltcomputerdesigns.com/Security.htm
Jeff Conrad's Access Junkie List:
http://home.bendbroadband.com/conradsystems/accessjunkie.html

 

[Guest]

Can I have user input on a query? Right now, I have the user pull up a form
and input the required information. It is then trapped on the associated
tables for review.

Can I do this same thing with a query? I'll play with it a bit.

Again, Thanks

 

[Guest]

Looks like I still have a lot of homework to do to fully understand and
utilize this program.

Thanks for the start.