Home All Groups Group Topic Archive Search About
Author
22 Nov 2006 12:12 AM
Kil
Hi,

I have an Access database with multiple tables. I want to be able to
restrict certain domain users from certain tables and allow them to edit the
others. Is this possible and if so how?

Thank you!

Author
22 Nov 2006 12:33 AM
Douglas J. Steele
Sorry, there's no way to link Access security to Active Directory
information.

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no private e-mails, please)


Show quoteHide quote
"Kil" <K**@discussions.microsoft.com> wrote in message
news:722E7E7D-E9A0-4ADB-AFAA-1628E71FFC25@microsoft.com...
> Hi,
>
> I have an Access database with multiple tables. I want to be able to
> restrict certain domain users from certain tables and allow them to edit
> the
> others. Is this possible and if so how?
>
> Thank you!
Author
22 Nov 2006 11:36 PM
David W. Fenton
"Douglas J. Steele" <NOSPAM_djsteele@NOSPAM_canada.com> wrote in
news:eL4dm3cDHHA.4312@TK2MSFTNGP06.phx.gbl:

> Sorry, there's no way to link Access security to Active Directory
> information.

That's not entirely true. You'd have to programatically duplicate
your domain security (you don't necessarily need to access the
information through AD, unless you want to use AD-specific features,
like Organizational Units, as opposed to traditional domain
users/groups) in Jet's user-level security, but this could be done
programmatically. You could use domain group membership and
duplicate that structure in Jet user-level security groups.

Not simple, but also not even close to impossible.

--
David W. Fenton                  http://www.dfenton.com/
usenet at dfenton dot com    http://www.dfenton.com/DFA/