Validate network ID

[Pat Hartman]

I have the API call to obtain the network ID of the person logged into the
computer on which the code is running. But, what I need is a way to
validate a network ID that is typed into my people table. Security in my
app is controlled by user and when a user opens the app, I get their network
ID from Windows. The problem is that I would like to prevent typos when the
administrator creates a person record in the people table by validating that
the networkID is actually a valid ID.

 

[Jeff Boyce]

Pat

Are you saying that you are storing the person's ID AND using a getNetworkID
routine?

If so, won't that mean extra maintenance keeping the network IDs and the
table IDs in sync?

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[Pat Hartman]

In order to know who has access to which parts of the application, I need to
maintain an internal list of users. This would be similar to using Access
security, where you would have the same problem, except I have created a
much simpler structure. When a person uses a feature in the application, I
verify that they are allowed to by comparing their network ID which I
capture via the windows API to the internal table of accessible features.
The problem is that we occasionally have issues when a person is added to
the database and their networkID is mis-entered. I let them into the app
because with the exception of certain things, everyone can use everything.
By doing this, I don't have to maintain a list of all potential users, I
only have to manage the list of people who have certain privileges. This
means that they can go for some time before they run into an issue and it
causes a lot of confusion. I admit it is a small thing but if I can prevent
this type of error, I would like to.

 

[Albert D. Kallal]

I have the API call to obtain the network ID of the person logged into the
computer on which the code is running. But, what I need is a way to
validate a network ID that is typed into my people table.

When you say validate, do you mean seach/test for the existance of this user
name in the table?

You can go:

dim strWhere as string

strWhere = "UserName = '" & fosUserName() & "'"

if dcount("*","tblUsers,strWhere) > 0 then
'...valid user
else
' not a valid usere
end if

You can also use dlookup, and could pull additional values from your user
table (such as user initials, or what not...).

 

[Mark]

I needed something similar, but for a different function. What I ended up
doing was contacting our technology group who was able to pull a list of
network IDs of all users who had access.

If I understand you correctly, you might want to see if that's an option.

 

[Pat Hartman]

I sent a reply to this on Friday but I don't see it so I'll do it again. I
am maintaining an internal list of users along with what they are authorized
to do. This is very similar to what the ULS did for us but does no more. I
was looking for a way to validate the UserID given when a person was added.
I have found two solutions but both require the user's ID and domain. The
domain I can handle but since an admin is entering the new people, I don't
want him to have to ask for a password. That sort of defeats the purpose of
passwords.