Database design protection when sharing a database in Acce..

shortwork01 · External Since: Oct 11, 2009 Posts: 1

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.

Jeff Boyce · External Since: Oct 12, 2009 Posts: 1

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" <shortwork01 RemoveThis @discussions.microsoft.com> wrote in message
news:E167A9BB-4647-4225-BE1F-5A1892174ED9@microsoft.com...
> 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 · External Since: Apr 25, 2006 Posts: 216

"shortwork01" <shortwork01.TakeThisOut@discussions.microsoft.com> wrote in message
news:E167A9BB-4647-4225-BE1F-5A1892174ED9@microsoft.com...
> 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