Re: Access 2003 and Active Directory

On Mon, 10 Dec 2007 11:02:00 -0800, HighlanderMom
<HighlanderMom@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote:

Yes, with a bit of code.
In the Form_Open write:
if not IsMemberOfGroup("SomeGroup") then
Cancel = True

This will cancel the opening of the form if the user is not a member.

Left to do is to write the function IsMemberOfGroup, which takes a
group name and checks with Active Directory if the current user (get
from Windows API call (http://www.mvps.org/access/api/api0008.htm)) is
a member of the given group. There are plenty of examples on the net
on how to do that.

-Tom.



I am fairly certain that I know the answer to this, but just in case I'm
missing something (it's been known to happen).

Is it possible to set up permissions to specific Access 2003 forms using
Active Directory groups?

Thanks,

.

Loading