Access Security FAQ 2

[elizabeth]

Many thanks to <b>svegal</b> for finding this great link. I'm pasting the TOC in here so that people will find it easily when using the search engine:<br>
<br>
<A HREF="

http://support.microsoft.com/support/Access/Content/SECFAQ.asp"

TARGET="_new">

http://support.microsoft.com/support/Access/Content/SECFAQ.asp</A><br>

<br>
<b>Table of Contents</b><br>
<br>
1.What are the steps to secure a database?<br>
2.In a nutshell, how does Microsoft Access security work?<br>
3.What has changed in Microsoft Access security between Microsoft Access 2.0, Microsoft<br>
Access 95, and Microsoft Access 97?<br>
3.1 Table 1: DAO Security Constants<br>
4.How can I set a single password on my database?<br>
4.1 Database Password Bugs<br>
5.How can I clear a user's forgotten password?<br>
6.What's the best way to convert my secured Microsoft Access 2.0 application to Microsoft<br>
Access 95 or Microsoft Access 97?<br>
7.What's all this about a security hole in Microsoft Access 2.0?<br>
8.How can I secure just my code without users having to log on?<br>
9.How do I delete the Admin user?<br>
10.How do I implement field-level or row-level security on my tables (RWOP or queries with Run<br>
Permissions set to Owners')?<br>
11.Why can't I get my RWOP append query to run?<br>
12.What is the difference between an &quot;attached&quot; table and a &quot;linked&quot; table?<br>
13.How do I manage attached tables using Microsoft Access security?<br>
14.What permissions are necessary to update table attachments?<br>
14.1 Using RefreshLink to reattach tables<br>
14.2 Using TransferDatabase to reattach tables<br>
14.3 No Permissions necessary Using the Connect property to reattach tables<br>
14.4 Error messages<br>
15.Why do users require permission to create new tables in order to update a table attachment?<br>
16.What happens when the front-end database permissions on an attached table differ from<br>
those in the back-end database?<br>
16.1 Creating new links<br>
16.2 What permissions should you set for &lt;New Table/Queries&gt;?<br>
16.3 Updating or refreshing existing links/attachments<br>
16.4 Synchronizing permissions<br>
17.How can I retrieve the &quot;most restrictive&quot; permissions for attached tables?<br>
18.Can I prevent users from attaching tables?<br>
19.How do I work with a secured application and an unsecured application at the same time?<br>
20.How do I keep users from viewing Code Behind Forms?<br>
21.How can I tell who is logged on to my shared, networked application?<br>
22.How can I obtain group and user membership information programmatically?<br>
23.How can I obtain the groups that the current user belongs to without hard-coding an Admins<br>
ID and password in the code?<br>
24.How can I prevent users from creating new objects in my database?<br>
25.How can I prevent users from updating any tables from any means other than through forms?<br>
26.How can I secure some parts of my application (an add-in), yet make others totally open to<br>
any Microsoft Access user?<br>
27.How do I prevent users from holding down the SHIFT key to bypass the AutoExec macro?<br>
28.How do I prevent a run-time application from being opened in full retail Microsoft Access?<br>
29.Does Microsoft Access security still work if I use OLE automation or Microsoft Query to<br>
manipulate Microsoft Access tables?<br>
30.How can I use the Security Wizard without creating an encrypted database?<br>
31.When I use the Security Wizard in Microsoft Access 2.0, it runs to 99%, and then freezes<br>
32.I thought I secured my database, but someone opened it with his or her own workgroup file.<br>
Is Microsoft Access security broken?<br>
33.I want users in other groups besides the Admins group to be able to administer the database<br>
and add accounts<br>
34.How can I &quot;de-secure&quot; a database?<br>
35.I lost/forgot my password and can't get into my database<br>
36.Do I need a separate workgroup file for every database I develop for my department?<br>
37.How do I use DAO to manipulate permissions?<br>
38.I created a user in code but the user isn't in the Users group and can't start Microsoft<br>
Access<br>
39.I created a user and I can't log on as that user<br>
40.I ran the Security Wizard but users from another workgroup can still open the database<br>
41.How do I implement security when I am using Microsoft Visual Basic® 3.0 as a front-end?<br>
42.Do I need to use a System.mda when I'm using Visual Basic to control secured objects?<br>
43.How do I open a password-protected database from Visual Basic?<br>
44.Additional sources of information