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:
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:
- Open each data access page that you created before you set the Admin password in Design view.
- View the connection properties for the data access page.
- Select the All tab, and then scroll down to Jet OLEDB: System database.
- Type the full path to your workgroup information file, for example, C:\Program Files\Microsoft Office\Office\System.mdw.
- Click the Connection tab, and then click to clear the Blank Password check box.
- Click OK, and then test the page in your browser.
Note that as the page opens, you are prompted for the password.
Modification Type: | Minor | Last Reviewed: | 9/27/2006 |
---|
Keywords: | kbDAP kbpending kbprb KB275119 |
---|
|