Access 2002/2003 permissions

[MartinX]

I'm a systems admin trying to help someone develop a database and have two
questions:

1) Can I use Windows AD accounts to grant permissions to objects in Access?

2) Does SQL Server 2005 Express Edition support Windows AD account
integration?

 

[Guest]

Hi Martin,

1.) No.

2.) I don't know.


Tom Wickerath
Microsoft Access MVP

http://www.access.qbuilt.com/html/expert_contributors.html
http://www.access.qbuilt.com/html/search.html
__________________________________________

 

[David W. Fenton]

I'm a systems admin trying to help someone develop a database and
have two questions:

1) Can I use Windows AD accounts to grant permissions to objects
in Access?

Not directly. You'd have to run Jet user-level security in the
background, drawing its structure from domain security (AD is not
necessary, unless you need to use Organizational Units -- domain
users/groups are all available through standard longstanding API
calls).

2) Does SQL Server 2005 Express Edition support Windows AD account
integration?

Dunno.