Password protect

[ccs2]

Does anybody know how to restrict access to parts of the dbase by password protection on a button, best of all on the switchboard?

Cavan Stewart

 

[MakeItSo]

Do you have a workgroup, so any user has to login?
If not, create one (with Wrkgadm.exe in the Office/103x folder)

Then you can assign different rights to each user/group.

If you need something more specific, you could also add some code like this to the affected forms:

Dim SU As Variant 'SuperUser-Array
Dim found As Boolean

SU = Array("superuser1", "superuser2", and so on)
For i = 0 To UBound(SU)
If LCase(Application.CurrentUser) = SU(i) Then
found = True
Exit For
End If
Next
Me.YourSuperUserControl.Visible = found

If you choose "Visible" or "Enabled" depends on what the Control you would like to protect does...

Does that help you?

makeItSo

Andreas Galambos
EDP / Technical Support Specialist
Bowne Global Solutions Wuppertal, Germany
(andreas.galambos@bowneglobal.de)
HP:

http://home.arcor.de/andygalambos

 

[jbento]

Try this thread. I just looked at it. It should help and it's very simple.

thread702-695067


Jerome Benton
JERPAT Web Designs

http://www.jerpat.org

GOD Is Good All The Time!!!