Password Protection

[Naomi]

I am having some problems with password protecting my
Access database. I don't have a lot of experience doing
this sort of thing so here goes my attempt at explaining
my problem.
I want the database to open in a view which can not be
edited. Users should only be able to input data and
print reports. They should not have access to modify the
database in any way. The Startup section is set up such
that all of the following boxes are not checked (Display
database window, Allow full menus, Allow default shortcut
menu, Allow Built-in toolbars, and Allow toolbar/Menu
changes.) So, when a user opens the database the start
menu appears and they only have access to the forms and
reports. If I hit Shift and double click the file it
opens so that I can edit it (Displays Database Window)
I set a password and it requires the database to be open
in the "exclusive use" mode in order to set it. After
setting this password I am unable to open the database so
that it will open in the format that I am able to edit
it. Is there a way to password protect this database and
have it open in the two different formats for users and
administrators? Perhaps I haven't set the permissions
correctly but I am the administrator and users are set to
not have privileges to edit. I would like to make this
as idiot proof as possible. Does anyone have any
recommendations or solutions to my problem?

 

[Eric Butts [MSFT]]

Hi Naomi,

You need to invest sometime in learning how to use Microsoft Access
User-Level Security. See:

Description of how to help protect a Access 2000 database
http://support.microsoft.com/default.aspx?scid=kb;EN-US;254372

ACC2000: Microsoft Access Security FAQ Available in Download Center
http://support.microsoft.com/default.aspx?scid=kb;EN-US;207793

I hope this helps! If you have additional questions on this topic, please
respond back to this posting.


Regards,

Eric Butts
Microsoft Access Support
(e-mail address removed)
"Microsoft Security Announcement: Have you installed the patch for
Microsoft Security Bulletin MS03-026? If not Microsoft strongly advises
you to review the information at the following link regarding Microsoft
Security Bulletin MS03-026
<http://www.microsoft.com/security/security_bulletins/ms03-026.asp> and/or
to visit Windows Update at <http://windowsupdate.microsoft.com/> to install
the patch. Running the SCAN program from the Windows Update site will help
to insure you are current with all security patches, not just MS03-026."

This posting is provided "AS IS" with no warranties, and confers no rights

--------------------
| Content-Class: urn:content-classes:message
| From: "Naomi" <[email protected]>
| Sender: "Naomi" <[email protected]>
| Subject: Password Protection
| Date: Wed, 22 Sep 2004 09:49:27 -0700
| Lines: 27
| Message-ID: <[email protected]>
| MIME-Version: 1.0
| Content-Type: text/plain;
| charset="iso-8859-1"
| Content-Transfer-Encoding: 7bit
| X-Newsreader: Microsoft CDO for Windows 2000
| Thread-Index: AcSgxB+HYg8GRZigSgyB0qUUlREuVA==
| X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4910.0300
| Newsgroups: microsoft.public.access.setupconfig
| Path: cpmsftngxa06.phx.gbl
| Xref: cpmsftngxa06.phx.gbl microsoft.public.access.setupconfig:31425
| NNTP-Posting-Host: tk2msftngxa11.phx.gbl 10.40.1.163
| X-Tomcat-NG: microsoft.public.access.setupconfig
|
| I am having some problems with password protecting my
| Access database. I don't have a lot of experience doing
| this sort of thing so here goes my attempt at explaining
| my problem.
| I want the database to open in a view which can not be
| edited. Users should only be able to input data and
| print reports. They should not have access to modify the
| database in any way. The Startup section is set up such
| that all of the following boxes are not checked (Display
| database window, Allow full menus, Allow default shortcut
| menu, Allow Built-in toolbars, and Allow toolbar/Menu
| changes.) So, when a user opens the database the start
| menu appears and they only have access to the forms and
| reports. If I hit Shift and double click the file it
| opens so that I can edit it (Displays Database Window)
| I set a password and it requires the database to be open
| in the "exclusive use" mode in order to set it. After
| setting this password I am unable to open the database so
| that it will open in the format that I am able to edit
| it. Is there a way to password protect this database and
| have it open in the two different formats for users and
| administrators? Perhaps I haven't set the permissions
| correctly but I am the administrator and users are set to
| not have privileges to edit. I would like to make this
| as idiot proof as possible. Does anyone have any
| recommendations or solutions to my problem?
|
|