Help with Security

[Angeline]

Hi, I have been trying to read up on security for Access 2007 and have come
across the comprehensive document that seems to apply only to 97-2000
versions. Where I am coming unstuck is how to access the Workgroup
Administrator Program? I tried following instructions from the Microsoft
Support website, which said; open a module and type in: DoCmd.RunCommand
acCmdWorkgroupAdministrator into a 'sub' but I am so bad with VB, I don't
even understand how I run this once I have done it? Very confused hope
someone canhelp.

I just need to apply some security to certain rows in the main table I have
created in a database. Thank you

 

[Tom van Stiphout]

On Sun, 28 Jun 2009 21:44:01 -0700, Angeline

You can type that command in the Immediate Window that appears with
Ctrl+G, and hit Enter.
Workgroup security is probably not a good choice for "applying some
security to certain rows". It is also an advanced topic you should not
undertake without studying and fully understanding that comprehensive
document (I am assuming you are speaking of the Access Security FAQ).

If you tell us a bit more about your needs, we may be able to suggest
simpler alternatives.

-Tom.
Microsoft Access MVP

 

[Tom van Stiphout]

On Wed, 01 Jul 2009 02:28:55 GMT, "Chris O'C via AccessMonster.com"

And then so often, even after your good deed, we hear nothing further
from the OP. Perhaps they found an answer on their own, or are not
familiar with how user groups work.

-Tom.
Microsoft Access MVP