Hide "Form Design" Option on right-click Menu

[TQ]

Hi,

When I view a from in Form View, if I right click on the the from, a drop
down menu will appear which has the option "Form Design"; this option will
display the form in the design view. How can I hide or grey this option and
won't allow the user to access the design view. Thanks!

 

[Allen Browne]

When I view a from in Form View, if I right click on the the from, a drop
down menu will appear which has the option "Form Design"; this option
will display the form in the design view. How can I hide or grey this
option
and won't allow the user to access the design view. Thanks!

Create an MDE for the user.

 

[strive4peace]

Hi TQ,

you can protect the design view of forms by turning your MDB into an
MDE. MDE files cannot be changed (except for table and query design and
data); design view of forms, reports, and code cannot be viewed.

To make an MDE, choose this option from the menu -->

Tools, Database Utilities, Make MDE File...


Warm Regards,
Crystal

remote programming and training

Access Basics
8-part free tutorial that covers essentials in Access
http://www.AccessMVP.com/strive4peace

*
have an awesome day
*

 

[Denver]

hi strive4peace,

i try working on the way you specify on this thread but no luck...
my first attept to make my current database to be converted to MDE....
a dialog box prompt ("You cannot create a Engineering Database ADE or MDE
file from a database saved in Engineering Database 2000 format.Convert the
database to the current version pf Engineerin Database.Then create the ADE or
MDE file.)
.......so i did concert it to current access to 200-2003 file format, the i
named it and saved as db2.mdb........then i open the db2.mdb and make MDE
file then a dialog box promt>>>>>>"Micorsoft Office Access was unable to
create an MDE database"...

what im going to do? or do i miss something?

i really appreciate for a help.....

thanks

denver

 

[Allen Browne]

Here's a list of things to check if you run into problems creating an MDE:
http://www.access.qbuilt.com/html/conversion.html#CannotMakeMDE