How to hide field from User

[Ty Archer]

Hi, I have a database with workgroup security. I want to make certain fields
invisible only to one user group. How can I do this?

 

[Tom van Stiphout]

On Sat, 5 Dec 2009 08:21:01 -0800, Ty Archer

Check with the Access Security FAQ, chapter "How can I obtain group
and user membership information programmatically?"
It can be downloaded from microsoft.com. You should really study and
fully understand it before working with workgroup security. It is an
advanced topic and you can lock yourself out if you are not careful,
or imperfectly implement it if you think you can simply click your way
through a wizard.

-Tom.
Microsoft Access MVP

 

[Arvin Meyer [MVP]]

Hi, I have a database with workgroup security. I want to make certain
fields
invisible only to one user group. How can I do this?

Here's a slew of security tips. The security FAQ (first link) has the answer
to your question:

Security FAQ
http://support.microsoft.com/download/support/mslfiles/SECFAQ.EXE

Lynn Trapp's summarization:
http://www.ltcomputerdesigns.com/The10Steps.htm

KB articles:
http://support.microsoft.com/default.aspx?scid=KB;en-us;q165009
http://download.microsoft.com/download/access97/faq1/1/win98/en-us/secfaq.exe
http://support.microsoft.com/default.aspx?kbid=325261

Joan Wild's articles:
http://www.jmwild.com/security02.htm
http://www.jmwild.com/security97.htm
http://www.jmwild.com/SecureNoLogin.htm
http://www.jmwild.com/Unsecure.htm