is there any way i can have different menu bars appear
for different logged on users in a secure database?

if so how can i do this?

i also need to make sure that the users cannot modify
the menu bar's or view any other menu bar's

thanks in advance

MICK

I think this should work.
Sub FormOpen()
    Select Case CurrentUser
            Case "Joe"
                Me.MenuBar = "Joe's MenuBar"
            Case "Mary"
                Me.MenuBar = "Mary's MenuBar"
    End Select
End Sub

Mick skrev i meldingen ...

1.Yes, use the AutoExec macro to test which user (or group)  and then set
the menu accordingly!

2. Look in Tools/Startup, there's a flag that you can set (allow menu
change), you can also do this through code.

HTH

RB