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



The information in this article applies to:

  • Microsoft Access 2002

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.

MORE INFORMATION

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.

Modification Type:MinorLast Reviewed:9/27/2006
Keywords:kbDAP kbpending kbprb KB275119