User Limitations

L

Larry G.

I have Access 2002, I would like to be able to limit users to change DATA
only, and not be able to make changes to forms, reports or queries. Is there
a way for me to set this up? The database is going to be stored on a shared
hard drive that only 10 users will have access to.
 
I

Immanuel Sibero

Hi

- I think MDE would still let users make changes to table and query
definitions, and others.

- To the original poster, if you havent already split your database, you
should split first before making an MDE and distribute it to each user.
http://www.granite.ab.ca/access/splitapp/index.htm

- To the original poster, to achive what you stated in your post, consider
using the Access ULS (user level security). Access ULS is not for the faint
of heart. It is very detailed and has a steep learning curve. You should not
attempt it without following MS Security FAQ, line by line, word for word.
And then, practice on a backup copy of your database, and practice more than
one time.
Excellent reference on Access Security:
http://www.jmwild.com/Accesssecurity.htm



HTH,
Immanuel Sibero
 
O

Ofer

with mde the users can still change the tables, queries and macros
only the forms, reports, and modules are protected

To protect everything install access run time at the stations and not a full
access.
that way you dont have to buy license for each pc, only for the developer
station.

With run time, running mde the users will have no access to the application
 
L

Larry G.

That is kind of out of the question since all the computers in the office are
running office 2002 or Office XP. I think that the best thing to do is to
follow Immanuel's suggestion about setting the work group up. Thanks tho!
 
I

Immanuel Sibero

Larry G.

There is another option. Really depends on user sophistications and
knowledge of Access. Only you can be the judge of whether this is viable.
But for example, there is an alternative where you can reasonably lock
unsophisticated users from the guts of the database by using startup form,
and disabling bypass keys. Each and every functionality of the application
is made available only through customizable menus and submenues. Under this
scenario, you're really not securing the guts of the database, but you're
taking design modes away from the menu structure (i.e. users wont be able to
get to design modes).

Again, this assumes fairly unsophisticated users. (Although, I have run into
an Access "developer" who didn't know about this, so "unsophisticated" users
can go a long way). If this is a viable option for you, then it's not
necessary to use the Access ULS which, again, has a steep learning curve.

Post back if you need more info.

HTH,
Immanuel Sibero
 
O

Ofer

If that what you decide to do then when you load the application dont forget
to run the code
docmd.RunCommand acCmdWindowHide
to hide the window with all the objects
 
O

Ofer

Also disable the F11 key, if the user will hit it by mistake it will put the
window with all the object in front
you can do that by creating a macro called autokeys
 
O

Ofer

Larry G. said:
I have Access 2002, I would like to be able to limit users to change DATA
only, and not be able to make changes to forms, reports or queries. Is there
a way for me to set this up? The database is going to be stored on a shared
hard drive that only 10 users will have access to.
Click to expand...
 
Top