Environment Question

[bluemat]

Can I set the permissions in Access to mirror those on a network system?

Idon't want to use the access security file, I just want people to have various restrictions according to their login when they access the office network.

Thanks

 

[Scoty]

This is kinda a crude security (and anybody that has any vb skills could crack it) but on my load form in the load event I use

Select Case Environ("UserName")
     Case "Manager" or "AsstManager"
         DoCmd.OpenForm "Management"
     Case Else
         DoCmd.OpenForm "OtherUser"
End Select

DoCmd.Close acForm, Me.Name

I use Win Nt 4.0 So I only know the Volatile Environment calls for WinNt. Again this is very basic security. But to be quite honest I havent hade any "OtherUser" in the Management form Ever.

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

 

[bluemat]

Cheers Scotty

I will give it a blast