Access Permission

[Guest]

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!

 

[Douglas J. Steele]

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

 

[David W. Fenton]

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.