Is it possible to make one of the objects

[kat25]

Hi,

I have a MDE database with no security/permission settings established yet. I would like to have permission set on only
one of the objects (a command button) on the form.
I have one group of users (3 people) who will need for this
command button to be active and I have another group of users (15 people) would should not be able to click on the
command button.

Here is my questions:
1. Is it possible on a MDE database to set permission on this object. (No security/permissions are in effect on the form).

2. If possible can you help me with the permission setting or if this can be accomplished by code.

Thank you kindly,
kat

 

[RickSpr]

Access user security can be used to set permissions for opening the database, or permissions on the objects in the Database Window, but it does not define permissions on controls within a form (nor, for that matter, fields in a table).

To manage access to a control, you'll have to write code, either to hide the button or to respond differently depending on the user. Of course, you can't change any code in an MDE file, so that won't work in this case either.

I think you're going to have to back up to the .mdb file from which the .mde was created, and create custom code there.

Rick Sprague
Want the best answers? See faq181-2886
To write a program from scratch, first create the universe. - Paraphrased from Albert Einstein