system.mdb

[SP_1]

Hi

Access uses system.mdb to allow management of user access to the database.

Can Access be somehow linked to Windows Server 2003 so that management of
user access can be done in conjunction with Windows active directory ? In
other words, when assigning permission to different tables and forms inside
Access, can Access get the access to the list of users that Windows has ?


Thanks
Steve

 

[Tom van Stiphout]

Actually Access uses system.mdw, which is indeed a renamed mdb.
No, there is no direct integration with AD. You'll have to write that
yourself.

-Tom.
Microsoft Access MVP

 

[SP_1]

You're right.... .mdw.

I don't know about SQL server, but is that an option to provide AD
integration without coding ??

Steve

 

[Tony Toews [MVP]]

I don't know about SQL server, but is that an option to provide AD
integration without coding ??

Not to my knowledge. Although SQL Server has it's own security model
which can be by Windows user/group if you want it to be.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/

 

[David W. Fenton]

Not to my knowledge. Although SQL Server has it's own security
model which can be by Windows user/group if you want it to be.

A whole bunch of people seem to think that NTFS security and Active
Directory are two different thinks. AD is a user interface to NTFS
security and that's all.

 

[Tom van Stiphout]

On 19 Sep 2008 21:39:41 GMT, "David W. Fenton"

I am one of the bunch. AD (among MANY other things) gives me the
option of creating users and assigning them to groups. Then I can
write code (e.g. using LDAP) to query that structure to see if I want
to give members of some group access to some feature of my
application.

-Tom.
Microsoft Access MVP

 

[Tony Toews [MVP]]

Not to my knowledge. Although SQL Server has it's own security model
which can be by Windows user/group if you want it to be.

Just to clarify my posting. You can use AD integration but you'll
have some very interesting VBA code to figure things out.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/

 

[David W. Fenton]

On 19 Sep 2008 21:39:41 GMT, "David W. Fenton"

I am one of the bunch. AD (among MANY other things) gives me the
option of creating users and assigning them to groups. Then I can
write code (e.g. using LDAP) to query that structure to see if I
want to give members of some group access to some feature of my
application.

But that's because it provides an *interface* to do so. I'm sure
there are API calls to do it directly via NTFS security.

I've seen too many cases where someone asks for getting the AD logon
when what the mean is the NTFS logon, and they are happy with the
standard API code to get the logon (which has nothing to do with AD
at all).