Me as admin, several unknown's as user

  • Thread starter Thread starter JJ
  • Start date Start date
J

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
 
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
 
Back
Top