Re: How do I lock the unhide database window menu option?

On Thu, 19 Jul 2007 13:32:03 -0700, RSharp <RSharp@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote:

We are using Office XP and 2003. I have a database that contains sensitive
information that I would like to secure.

First things first: If you have truly sensitive information, Access is NOT the place to store it. Consider moving your
data storage to a true server database (MS SQL Server, MySQL, Oracle, etc) if you need real security. Access security is
weak and easily broken.

It consists of a front end with all
the forms, queries, and reports and a linked backend that contains the
tables. I have turned off the special access keys to disable the F11 key to
open the database window but there is still the matter of the user going to
Window->Unhide and viewing the database window that way. I thought about
customizing the menu bar and removing that option but I still need to be able
to access it.

You can build a menubar that does everything the default menubar does, then tell Access to use that menubar (in the
Startup options).

Is there a way to password protect the database window only?

No.

I do not want to have to manage users in Access. I want the general user to be
able to open the database, view their forms and reports but not be able to
open the database window or modify the menu bar to see the database window.
But I need to be able to get to it periodically to do maintenance. Basically
I do not want the users to be able to get to the underlying tables and see
the data.

You can secure an Access database without requiring a login; see Joan Wild's site for info on this:

www.jmwild.com

Regarding maintenance - you can always turn the database window back "on", then restart Access ... you can also provide
certain users with a different menu (i.e. an Admin menu, a Developer menu, etc etc) so that certain users or groups of
users would have access to different portions of Access. This is typically done in your startup form where you might
show/hide menu items based on username, user Group membership, etc etc ...

Scott McDaniel
scott@xxxxxxxxxxxxxxxxxxxxxxxxx
www.infotrakker.com
.

Relevant Pages

  • Re: Data Entry Form
    ... Some of the things you can do to "secure" a form/app... ... Access opens to that form. ... Hide Database Window = YES... ... quick and dirty trouble ticket. ...
    (microsoft.public.access.forms)
  • Database Security
    ... original post. ... I hop some one can help? ... Can anyone tell me how to secure my database without using ... database window. ...
    (microsoft.public.access.security)
  • Securing the database window.
    ... Is there a way to secure the database window to end users ... using code, w/o using Access Security? ...
    (microsoft.public.access.security)
Loading