Retrieving network in user names

[Synergy Tooling Systems]

I would like to retrive the user from a Windows 2000 server to populate a
list box for use in a Security System I wrote for a client app, to set up
users with the same name as their network login names.

There is an API on the Access Web,

Enumerating user accounts in a NT Domain

which seems like it could provide what I need, however I don't understand
it well enough to know how to retrieve the data. I see that it write to the
debug window, however, but that won't help much.

Or another method would be utilizing Windows Authentication to log onto the
Database then pulling the User info at logon time.

Any help in this area is appreciated.

God Bless,

Mark A. Sam

 

[Rick Brandt]

I would like to retrive the user from a Windows 2000 server to populate a
list box for use in a Security System I wrote for a client app, to set up
users with the same name as their network login names.

There is an API on the Access Web,

Enumerating user accounts in a NT Domain

Go back and look at that web site some more. There is also a function that
specifically returns the current network logon name.

 

[Synergy Tooling Systems]

Hello Rick,

I know that Function. My interest is to either be able to compile a
list of Win2000 users on the server or simply to have a system which
requires a Win2000 user authentication then a allows me to track the user is
logged on for loggin transactions.

I could do this manually, but that will require someone always knowing to
update the system manually. If I left, it would be problem. I want to
create a system where the users of the database match the users on the
server. I hope that makes sense.

God Bless,

Mark

 

[Synergy Tooling Systems]

Rick,

I see where you are coming from. I can check the user name as the DB
isopening and set up a logon but the issue then is the password. I would
have to collect their passwords or they would have a seperate password from
the DB which would caue unnesessary administration. I am thinking that the
passwords cannot be retrieived.

Mark

 

[Dan Artuso]

Hi,
You are correct, you can't get the passwords.
There are two options, have a seperate password, or have the user authenticate to
your app using his/her domain logon.

The latter can be done but is rather complicated. See:
http://www.mvps.org/vbnet/code/network/acceptsecuritycontext.htm

for the complete code. Be aware this site is for VB not Access.

 

[Synergy Tooling Systems]

Thank you Dan,

That should work. I'll check out the site.

God Bless,

Mark

 

[Synergy Tooling Systems]

Hello Dan,

The code was not designed to work with access.

Thanks for trying.

God Bless,

Mark

 

[Douglas J. Steele]

Looking at that code, I see nothing in it that should prevent it from
working with Access.

What problem are you running into?

 

[Synergy Tooling Systems]

Hello Doug,

WIthout looking it up again,

For one it uses a Checkbox Array.
It also uses a Scaling feature that isn't available in Access.

I thought I would try to pull identify the sections which apply to the
users, but decided I don't have the time to figure it out. I am not good at
reading Code and unfamiliar with anything other than Office VBA. When I
look at API's, it looks like a big blob of mush to me.

One would wonder how I could make a living at programming...lol.

Mark

 

[Douglas J. Steele]

Are we talking about the same code? The URL Dan posted was
http://www.mvps.org/vbnet/code/network/acceptsecuritycontext.htm

There's no checkbox array in that code that I can see, nor do I see any
Scaling.

 

[Synergy Tooling Systems]

Doug,

No that isn't the same code. I must have gotten to another page somehow.

Thanks, I will try this out.

Mark

 

[Synergy Tooling Systems]

Thank you Doug and Dan, I got it to work.

God Bless,

Mark