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:

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top