Prevent Users From Design View of a form

[Sha S]

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.

 

[Ray C]

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.

 

[Klatuu]

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.