Can I lock the form format to prevent changes?

[BetoWing]

After I distribute this app to the users, I occasionally get a call about a
form that has changed so that part of it is not visible. When I check it
out, I discover that in design mode the form has extended itself about double
so that the buttons are below eye level and the list box has extended out of
sight. There is no explanation how this happens! Users do duplicate this
app.

Is there a way to lock the form format so that no matter what happens, the
form will never change layout?

 

[Allen Browne]

Easy solution, Bob:
Tools | Database Utilities | Make MDE

Give them an MDE, and they simply cannot use desgin view or modify you code.

 

[BetoWing]

Allen,

OK, but that brings up another problem. If I make an MDE, it also locks up
all reports, right? I want my uses to be able to edit and make new reports
as they see fit. Can I make an MDE that allows this?

 

[david epsom dot com dot au]

1) set the form property to only "allow design changes" "in design view
only"

2) Sometimes people resize a form, then change their screen resolution.

 

[Allen Browne]

As you say, the MDE prevents them from messing with reports also.

It's still the best way to block them messing up your application, so how
about giving them another mdb, with linked tables, and they can create their
own queries and report in there?

 

[BetoWing]

Allen, I agree that am MDE is a good idea, and it never occurred to me to
have more than one application linked to the data. I may do that.

David, I already have the form set for design changes in design view only.

Thanks to both of you for taking the time to consider solutions to my problem.