Prevent access to Form Design

[Pete]

Is there a simple way (without using a Password or setting up Groups) to
prevent the casual user from changing the design of the Switchboard? It is
casual viewing and tinkering that has to be stopped. P.S. My first effort to
post this crashed, so it is hoped I am not posting the same message twice.
Such is not my intent. Many thanks.

 

[Marshall Barton]

Is there a simple way (without using a Password or setting up Groups) to
prevent the casual user from changing the design of the Switchboard? It is
casual viewing and tinkering that has to be stopped.

Make a working copy of your front end mdb file that compiles
without error. Then save the copy as an MDE file and
distribute that to your users. MDE files can not be edited
so you must keep your mdb file for you to make further
changes. The distributed MDE file really needs to be
separate from the back end tables mdb file so be sure you
have properly split your database before starting this
exercise.

See About MDE and ADE files in VBA Help for important
details.

 

[Pete]

Thanks. This is helpful. Do I take it that there is not a Property that could
be ticked or line of VB that would make the Design read-only or somehow lock
it down?

 

[Marshall Barton]

That's how to take it. MDBs can be modified. MDEs have
their VBA source removed and design is (mostly) disabled.

 

[John W. Vinson]

Thanks. This is helpful. Do I take it that there is not a Property that could
be ticked or line of VB that would make the Design read-only or somehow lock
it down?

You can open the database with the

/Runtime

switch on the command line - but of course a clever user can easily figure out
how to get around that.

The .mde file is better (not perfect) security against meddlesome users.