[AccessD] Access security integration with NT security groups

Mark,

Access does not use NT Security, it has its own security.  Access
security came into being long before M$ developed WinNT and WinNT
Security.  It would be nice if a future version of Access did allow
integration with NT Security, or whatever version of Windows Security is
in place then.

If you read the Access Security FAQ 
http://support.microsoft.com/default.aspx?scid=%2Fsupport%2Faccess%2Fcon
tent%2Fsecfaq%2Easp (watch for line wrap)
you will see it is recommended that you set up security for groups and
then assign individuals to groups.  Thus you, or whoever you appoint as
security administrator of the application, only has to add and delete
individuals from groups.

Charles Wortz
Software Development Division
Texas Education Agency
1701 N. Congress Ave
Austin, TX 78701-1494
512-463-9493
CWortz at tea.state.tx.us



-----Original Message-----
From: Porter, Mark [mailto:MPorter at acsalaska.com] 
Sent: Tuesday 2003 Mar 18 16:40
To: 'accessd at databaseadvisors.com'
Subject: [AccessD] Access security integration with NT security groups


An old client would like to secure their mdb and I'm wondering how easy
it would be to integrate Access security with NT security (ala SQL
Server). I'd like to focus on security groups, not individuals.

Does anyone have experience with this and can point me in the right
direction?  Or is it more trouble than it's worth?

(Win2k server, Win2K Pro desktops and Access 2000 mdb files.)

Thanks,

Mark Porter