Database design protection when sharing a database in Access 2007

[shortwork01]

Is there a way to protect a database design (tables) from being altered while
sharing access to that database? I have posted a form and tables for others
to populate with data, but want to protect the design/format from being
accidentally altered.

 

[Keith Wilby]

Is there a way to protect a database design (tables) from being altered
while
sharing access to that database? I have posted a form and tables for
others
to populate with data, but want to protect the design/format from being
accidentally altered.

If you stick to the old "mdb" format then you can apply user-level security
which is an advanced topic. User level security is not supported by the new
file format.

Keith.
www.keithwilby.co.uk

 

[Jeff Boyce]

Take a look at Access HELP for "mde" or "accde" -- depends on which version
of Access you are using.

--

Regards

Jeff Boyce
Microsoft Access MVP

Disclaimer: This author may have received products and services mentioned in
this post. Mention and/or description of a product or service herein does
not constitute endorsement thereof.

Any code or psuedocode included in this post is offered "as is", with no
guarantee as to suitability.

You can thank the FTC of the USA for making this disclaimer
possible/necessary.