ACC2002: UseXMLData Property Is Ignored with Offline Data Access Page (282345)
The information in this article applies to:
This article was previously published under Q282345 Advanced: Requires expert coding, interoperability, and multiuser skills.
This article applies only to a Microsoft Access project (.adp).
SYMPTOMS
When you are working offline with a data access page that is bound to XML, the page is updateable, even though it should be read-only. You may also notice that the UseXMLData property of the DataSourceControl still returns True after the page is offline.
CAUSE
The offline functionality of data access pages takes precedence over the UseXMLData property. As a result, the UseXMLData property of the page is ignored, and the data in the page is updateable.
RESOLUTION
To prevent a user from making updates in the data access page, set the RecordsetType property of the page to dscSnapshot. To set the RecordsetType property, follow these steps:
- Start Microsoft Access, and then open your data access page in Design view.
- On the View menu, click Properties to open a property sheet.
- On the Edit menu, click Select Page to ensure that you are viewing the properties of the page.
- In the property sheet, click the Data tab.
- Change the RecordsetType property to dscSnapshot.
- On the File menu, click Save.
- Close the data access page.
Now when you work online or offline with the data access page bound to XML, the page will always be read-only.
STATUS
This behavior is by design.
REFERENCESFor more information about working with data access pages offline, click Microsoft Access Help on the
Help menu, type about offline data in the Office Assistant or
the Answer Wizard, and then click Search to view the topics
returned.
Modification Type: | Minor | Last Reviewed: | 9/27/2006 |
---|
Keywords: | kbDAP kbprb KB282345 |
---|
|