Lockout Access to Design view

[Roger Bell]

Is there a simple way to prevent someone from changing
the Design view in Tables, Reports, Queries etc. This is
a single data base used on only one machine.

Thanks for any help

 

[TC]

Making an MDE copy of the database will stop people changing the design
of the forms, reports & modules. Search Help (or google) for MDE, for
more information.

To stop them changing the design of the tables & queries, you'd have to
implement Access user-level security. That is *not* a simple process -
at least for the first few times - so it might not suit your needs.

HTH,
TC