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.

"shortwork01" <(E-Mail Removed)> wrote in message
news:E167A9BB-4647-4225-BE1F-(E-Mail Removed)...
> 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

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.


"shortwork01" <(E-Mail Removed)> wrote in message
news:E167A9BB-4647-4225-BE1F-(E-Mail Removed)...
> 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.