prevent form design

[jrlh]

I created a Switchboard that leads to a data entry form
and would like to prevent my coworkers (who will be doing
the data entry) from making any modifications to either
the Switchboard or the form under Design View. How would
I go about doing this? I've created a macro to maximize
both of the screens, but if the user clicks the "Restore
Down" button (in between "Minimize" and "Close") and moves
the form, they are still able to access Design View.

Thanks!

Jennifer

 

[Rick Brandt]

I created a Switchboard that leads to a data entry form
and would like to prevent my coworkers (who will be doing
the data entry) from making any modifications to either
the Switchboard or the form under Design View. How would
I go about doing this? I've created a macro to maximize
both of the screens, but if the user clicks the "Restore
Down" button (in between "Minimize" and "Close") and moves
the form, they are still able to access Design View.

The app should be split (tables in one file, everything else in another).
This offers many advantages one of which is that you can have multiple
"front end" files all pointing to a common "back end" or data file. In
that scenario, you can then keep an MDB for yourself that you use for
development and only give your users front end files that you have
converted to an MDE.

This satisfies your goal as MDE files do not allow design changes to any
code-based objects (forms, reports, code).

BTW, each user would be given their own copy of the front end file rather
than sharing a common one.

 

[jrlh]

I'm very new at this database thing. I'm not sure how to
split an application or convert to an MDE file. Would you
please outline it for me?

Thanks!
Jennifer

Jennifer