Me as admin, several unknown's as user

[JJ]

I have a database that several unknown users from other
departments will be using. I need to allow anyone who
logs on to use the database but I dont want them seeing
anything but the form. I need for me to be the only admin
and lock everyone else out of the code, objects, tables
and everything else.

Please Help
JJ

 

[Albert D. Kallal]

You don't actually have to use security to implement this.

(however, it is not a bad idea). Hiding the interface is a separate issue
from ms-access security.

Try downloading the 3rd file on the following web page.

http://www.attcanada.net/~kallal.msn/msaccess/DownLoad.htm

Note how the interface is hidden, but I did not have to use security. You
will need to run the shift key code on that file to get in. You can find
that code example at:

http://www.attcanada.net/~kallal.msn/msaccess/msaccess.html

You should in general be distributing a front end to your users. That front
end should be a mde file. When you distribute a mde to your users, then they
can't make changes to forms or reports. However, in addition to using a mde
file, you should still hide the ms-access interface All of the options to
hide, and setup ms-access for distribution are in the tools-> startup. Also,
you do have your database split for the multi-user envoemnt...right?

For info on splitting:

http://www.granite.ab.ca/access/splitapp.htm

http://www.microsoft.com/accessdev/articles/bapp97/chapters/ba15_3.htm