Limiting Access to just tables and forms

[Tami]

I would like the users to only be able to enter, delete data to forms and to
view the data into the tables. I would like to block all access to all
design objects. How can I do this?

I tried the user level security wizard but not sure I was doing it correctly.

 

[Lynn Trapp]

Hi Tami,
You actually shouldn't allow your users to even view tables. They should
have access to the data in a form and/or report that you create for them.
User level security is what you need but you need to follow the Security FAQ
to the letter. You can find a link to it on the Security page of my website.

--
Lynn Trapp
MS Access MVP
www.ltcomputerdesigns.com
Access Security: www.ltcomputerdesigns.com/Security.htm
Jeff Conrad's Access Junkie List:
http://home.bendbroadband.com/conradsystems/accessjunkie.html

 

[Keith Wilby]

I would like the users to only be able to enter, delete data to forms and
to
view the data into the tables. I would like to block all access to all
design objects. How can I do this?

I tried the user level security wizard but not sure I was doing it
correctly.

Your users should access and manipulate data using only forms. They should
not have access to the tables. If you want to secure your app and want to
understand how security works then forget the wizard and start by reading
the MS FAQ - link on my web site.

Keith.
www.keithwilby.com

 

[david epsom dot com dot au]

First, only give the users an MDE (tools, database utilities).
That will block design access to forms and reports.

Hide all of the queries.

next,

Just remove all design permission for everything (tools,
security). That will block design access to everything else,
but of course anyone will still be able to reset the design
permission if they want to, as will you, if you want to
change anything.

For many internal developments, that is enough security.


next,

Try using the security wizard to try to secure the
database. No, you probably aren't doing it correctly,
you have to be very careful to get that to work, but
it's worth trying it once or twice before you ask questions
or read the "Access Security FAQ" (Google will find
that for you).

(david)