Viewing Netware login information using VBA

[dleiba]

G'day folks,

I am searching for a way to programmatically obtain a User's netware username AND password using VBA.

Is this possible?

If so, ANY assistance would be greatly appreciated.

Thanks

Dominic

 

[Scoty]

Domonic,
At my company we use novell login on an NT machine and I use environ("UserName&quot to get my people logged into the database. Some will say that environ can be duped but With novell I find that to be a little harder than some people would like to admit. Give it a try see if it works.

HTH
Scoty : Learn from others' mistakes. You could not live long enough to make them all yourself."
-- Hyman George Rickover (1900-86),

 

[dleiba]

Scoty,

Thanks a lot for responding.

How does the environ("UserName&quot code work exactly?

What is the syntax?

Also, how does it tie into the users that have been defined for the database?

Lastly, where do I use this code?

Thanks in advance!

Dominic

 

[Scoty]

Dominic,
the Environ("UserName&quot's syntax is exactly that. You can use it just as it is. Make it part of a condition statement. I use it in a select case ie

Select Case Environ("UserName")
      Case "Bill" Or "Don" Or "Scoty" Or "Peter"

'Do Nothing

      Case Else
           Application.Quit
End Select

The above example is just a real easy and quick lower level security script. I put it in the onload event of the initial form of the database. This way if the username is not bill or don or scoty or peter it will just quit the application without giving anyone access rights. Again this a lower level security script. Anyone with any Access Skill can easily bypass this measure.

HTH
Scoty : Learn from others' mistakes. You could not live long enough to make them all yourself."
-- Hyman George Rickover (1900-86),