Locking down an MS Access backend
First post on this forum, so go easy on me, yeah?
I'm working on an access database for my employer, and I'm trying to lock it down so that users have to go through the frontend (it's been split), with the backend closing on everybody but the administrator.
I think I've found a way to do it with macros, except for one tiny little problem. I can get the macro to evaluate if a user is an administrator, using conditions, but I can't figure out how to say "If user IS NOT administrator." Only "if user IS administrator." Is there a way to make a macro check if something is not true, so I can say "If user is not administrator, quit MS Access?"
Thanks a bunch.
An administrator in the Access database or an administrator in the network domain?
Microsoft MVP (Visual Basic)
Whatever you're using as a condition to define "administrator", follow it with [something] <> "administrator" and the action would be "Quit".
A balanced diet is a cookie in each hand.
pclement: It would be an administrator in the database.
Laurel: That looks like just about what I need. I will give it a go ASAP.
Thanks, both of you! Much obliged!
-- Android Development Center
-- Cloud Development Project Center
-- HTML5 Development Center
-- Windows Mobile Development Center