Microsoft KB Archive/275119

= ACC2002: Data Access Page Connects to a Database on Which an Admin Password Has Been Set Without Prompting for a Password =

Article ID: 275119

Article Last Modified on 9/27/2006

-

APPLIES TO


 * Microsoft Access 2002 Standard Edition

-



This article was previously published under Q275119



Moderate: Requires basic macro, coding, and interoperability skills.

This article applies only to a Microsoft Access database (.mdb).



SYMPTOMS
After you set a password for the Admin user, non-Admin users can connect to and view data from a data access page without being prompted for a password.



CAUSE
The data access page was created before you set the Admin password.



RESOLUTION
To resolve this issue, do the following:

First, set the Admin password before you create any data access pages. All pages that you create after the Admin password has been set will prompt users for a password before they are able to view the data in the browser.

Then:


 * 1) Open each data access page that you created before you set the Admin password in Design view.
 * 2) View the connection properties for the data access page.
 * 3) Select the All tab, and then scroll down to Jet OLEDB: System database.
 * 4) Type the full path to your workgroup information file, for example, C:\Program Files\Microsoft Office\Office\System.mdw.
 * 5) Click the Connection tab, and then click to clear the Blank Password check box.
 * 6) Click OK, and then test the page in your browser.

Note that as the page opens, you are prompted for the password.



Steps to Reproduce the Behavior

 * 1) Open the sample database Northwind.mdb.
 * 2) Click to highlight the Categories table in the Database window.
 * 3) On the Insert menu, click Page, click AutoPage: Columnar, and then click OK.
 * 4) Save the page as Categories.htm, and then close it.
 * 5) On the Tools menu, point to Security, and then click User and Group Accounts.
 * 6) Click the Change Logon Password tab, and then change the Admin password to a nonblank password, such as test.
 * 7) Quit Microsoft Access.
 * 8) In Microsoft Internet Explorer, browse to the Categories page that you just created.

Note that even though you assigned a password to Admin, you can browse and view the data through the page without being prompted for the Admin password.

Additional query words: pra dap system mdw non-blank non-null non-empty browse prb

Keywords: kbdap kbpending kbprb KB275119

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.