How do I stop users screwing up the form?

[flint]

I have seen that there is a lot written about security i.e. limiting
access to certain groups etc but it looks complicated!! Is there a
simple way of stopping users from screwing things up? Can I password
protect somehow or something? I'd like to limit their access to just a
nominated form where they can review, edit and delete data. I
certainly don't want them accessing the form design facility.

Flint

 

[Douglas J. Steele]

Convert your application into an MDE (under Tools | Database Utilities).
That removes the ability to make design changes.

 

[Arvin Meyer [MVP]]

In addition to Doug's suggestion of making an MDE, you can also use
User-Level Security to prohibit users from doing any design changes on
anything in the database. And you can require a password to view code. (In a
code window choose Tools >>> Properties >>> Protection tab).

Remember, that some changes in color scheme are fostered through the Control
Panel, and you cannot stop that without setting Group Policies in a Windows
domain.

 

[flint]

In addition to Doug's suggestion of making an MDE, you can also use
User-Level Security to prohibit users from doing any design changes on
anything in the database. And you can require a password to view code. (In a
code window choose Tools >>> Properties >>> Protection tab).

Remember, that some changes in color scheme are fostered through the Control
Panel, and you cannot stop that without setting Group Policies in a Windows
domain.

Many thanks to you both for your input.

Flint