Access2000-Limiting User Access

Joined
Jun 13, 2005
Messages
148
Reaction score
0
Access's tools menu allows the creator to limit access to database window and menus.
this can be bypassed by holding shift.

I need a way to do these permissions based on the machines loggined user.
i have figured out how to retrieve the user info, i just need the location and syntax that will allow me to use an if staement, basaed on the user, to restrict or grant access.

e.g. if username<>"administrator" then
hide database window
hide extra menus
end if
 
Last edited:
Back
Top