Prevent Users From Design View of a form

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Sha S - 22 Apr 2008 20:19 GMT

I would like to prevent users from opening a specific form in design view.
This includes preventing the form from opening when the user clicks on the
Design button in the Forms tab of the database window.

Thanks for any ideas.

Sha.

Reply to this Message

Ray C - 22 Apr 2008 20:37 GMT

If you want to do things the proper way, you need to incorporate user-level
security to your access database. Since this is only for a specific form, you
may not have a choice. If it were for all forms, you would be able to save it
as an MDE file but since it's for a specific form, you may not have a choice.

Secure your database then apply the proper permissions to that form only.

> I would like to prevent users from opening a specific form in design view.
> This includes preventing the form from opening when the user clicks on the
[quoted text clipped - 3 lines]
>
> Sha.

Reply to this Message

Klatuu - 22 Apr 2008 20:50 GMT

The easiest way is to create an mde and deliver that instead of the mdb.
Also, set the startup options to hide the database window and prevent the
user from being able to bypass your startup by holding down the shift key.

Signature

Dave Hargis, Microsoft Access MVP

> I would like to prevent users from opening a specific form in design view.
> This includes preventing the form from opening when the user clicks on the
[quoted text clipped - 3 lines]
>
> Sha.

Reply to this Message