Microsoft KB Archive/274381

= ACC2000: Access Permissions in the Data Link Properties Dialog Box Are Not Saved =

Article ID: 274381

Article Last Modified on 1/26/2005

-

APPLIES TO


 * Microsoft Access 2000 Standard Edition

-



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.



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.

