ACC2000: Access Permissions in the Data Link Properties Dialog Box Are Not Saved (274381)


The information in this article applies to:

  • Microsoft Access 2000
This article was previously published under Q274381
Novice: Requires knowledge of the user interface on single-user computers.

SYMPTOMS

When you open the Data Link Properties dialog box of a data access page in Microsoft Access and view the Advanced tab, the access permissions are set to Share Deny None. If you change the access permissions, and then close the dialog box, your changes are not applied, and the permissions are reset to Share Deny None.

RESOLUTION

You can set the page to be read-only in different ways. To properly secure your data, implement security on the data source. If you are using an Access database as the data source, apply Access user-level security. If you are connecting to another type of database by using an OLE DB Provider, implement the appropriate data security.

To simply set the page to be read-only, set the RecordsetType property to dscSnapshot. To do so, follow these steps:
  1. Open the data access page in Design view.
  2. On the View menu, click Properties. To be sure that the page is selected, click Select Page on the Edit menu.
  3. In the property sheet, click the Data tab, and then set the RecordsetType property to dscSnapshot.
The page is now read-only.

STATUS

Microsoft has confirmed that this is a problem in the Microsoft products that are listed at the beginning of this article.

MORE INFORMATION

Steps to Reproduce the Behavior

  1. Start Microsoft Access, but do not open a database.
  2. On the File menu, click New. Click Data Access Page on the General tab, and then click OK.
  3. In the New Data Access Page dialog box, click Design View, and then click OK.
  4. In the Data Link Properties dialog box, click the Provider tab, and then click Microsoft Jet 4.0 OLE DB Provider.
  5. Click the Connection tab, and then select the Northwind sample database as the data source.
  6. Click the Advanced tab. In the Access Permissions list, click to clear the Share Deny None check box, and then click to select the Read check box. Click OK.
  7. In the field list that appears, expand the Tables node. Drag the Customers table onto the page and drop the table as Individual Controls.
  8. On the View menu, click Page View.
  9. Add a new record to the table, and then save your changes.
  10. On the View menu, click Design View.
  11. In the field list, right-click the Data Source icon that is labeled Northwind.mdb, and then click the Advanced tab.
Note that access permissions on the Advanced tab have been reset to Share Deny None.

REFERENCES

For additional information about securing a Microsoft Access database, click the article numbers below to view the articles in the Microsoft Knowledge Base:

254372 ACC2000: Overview of How to Secure a Microsoft Access Database

207793 ACC2000: Microsoft Access Security FAQ Available in Download Center

Modification Type:MinorLast Reviewed:1/26/2005
Keywords:kbbug kbpending KB274381
©2004 Microsoft Corporation. All rights reserved.