Problem restricting users from forms via Security/Permissions

[blackduck603]

I am receiving an unexpected message when a user tries to launch a form that the user does not have permission for via the Access Security-Permissions setting that I have configured.

I am trying to set my Access db up so that Guest users can only access 2 Forms - the Switchboard and the Main form. There is a Maintenance Form and I don't want Guest users having access to it.

I have configured Security and created a Group named Guestgrp. I have also created a user named Guest that is assigned to the Users and Guestgrp groups.

The Users group is currently set up with NO permission for any form.


Here are the Guestgrp permissions for the forms, db and tables

The following forms have Open/Run and Read Design permission
Switchboard
MainForm

The following forms have NO Permissions selected
Maintenance Form

The database permission is set to Open/Run

Table permissions
The Guest group has Read Design and Read Data permission for all tables


so here is what happens...............
My Guest user can log in and launch the Switchboard form and can launch the Main Form from the switchboard.
BUT......................
When my Guest user clicks on the Switchboard button for the Maintenance Form, the following message pops up:
There was an error executing the command.

Is this the normal way for Access to indicate that the user does NOT have permission to access a form? I am guessing/hoping that it isn't and if configured properly there would be a message indicating that permission is denied or something of that nature.

If anyone has any comments, suggestions on the error in my ways, I appreciate any comments/suggestions/clarifications.

Thanks

 

[rainman89]

how about hiding the button so the guest doesnt even get tempted to click on it?

 

[blackduck603]

RE: Hiding the button

I am tempted, but the premise is that Access Security & Permissions is supposed to make this easier - with no need to modify code. The user either has permission or doesn't. I am part way there, but apparently I have done something wrong because the message being displayed (There was an error executing the command) does not seem right to me. I would hope that a permission related restrcition would indicate something about permission being denied instead of what appears to be an actual error with the form or db.

I certainly have not ruled out that I screwed something up while configuring the permissions, but I am quite confident that it is not a Form or DB error.....it's gotta be something amiss with how I implemented the Guest permissions - well I hope like heck....

thanks for the suggestion though.

 

[rainman89]

i found this that deals with the problems u are describing.... try this
http://www.microsoft.com/communitie...n_US_973e53c3-c10e-4523-9213-cdfd537838f1&p=1

 

[blackduck603]

Same message but not the same problem.

That guy only had the problem after installing a new Access Version and forgetting to apply a Service Pack.

I have no changes to Access and/or my OS whatsoever.

The only thing that I have changed is I configured Access security/permissions and the problem only appears for users that are restricted from Opening a specific Form. Access should eb NOT allowing the form to be opened (which it is) however, I would expect a better message.