Getting Access to run a Macro after denying permission to a file

F

Fuj

I have set up a work group allowing members to access certain parts of a
database, but not all of it. When a user tries to access a form or report
they are not privied to from the main switchboard, they get the proper "(i)
You do not have permission to run/edit this file. See your administrator for
access", and an "ok" button. When the user hits the "ok" button, the
database does not return to the switchboard, but rather kicks them to the
back-door (exactly the same as if the user opened the program with the
"shift" key pressed).

Is there a way to stop the automatic transfer to the design and instead run
a macro to get the user back to the switchboard?

Thanks for any insight out there....
 

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