Locking down an MS Access backend

[CelticWhisper]

Hello all.

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.

[pclement]

An administrator in the Access database or an administrator in the network domain?

[Laurel]

Whatever you're using as a condition to define "administrator", follow it with [something] <> "administrator" and the action would be "Quit".

[CelticWhisper]

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!