switchboard options access

[Guest]

hi all,
my switchboard form which inculde 8 options . each option will open another
options which i want to ristict for some usernames. so , what i am looking
for is like this example
1.user 1 : when this user chooses option 1 from the main menu of options ,
is should not allow him to access , and a message saying that access is
denied.

and so on for other options to be restricted for the concered user only .

what should i do for this? i dont want to have password prompt . i want the
system to check for the current username and match it with a code in the
switchboard form . any body can help with this issue.

 

[Rick B]

You can't do that in the built-in switchboard. You could build your own
forms and hide items to which users do not have access.

The bigger point here is that this error will already be issued by Access
without you having to modify the switchboard in any way. If you have set up
user-level security, and if the user does not have access to the object that
the switchboard mentions, then they WILL get the error message you mention.

If you have not implemented user-level security and forced your users to log
into the database, then obviously you will not be able to put the
appropriate object security in place.