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.