Microsoft KB Archive/225907

= ACC2000: AutoNumber Field with FieldSize of ReplicationID Can Be Manually Edited in a Data Access Page =

Article ID: 225907

Article Last Modified on 7/14/2004

-

APPLIES TO


 * Microsoft Access 2000 Standard Edition

-



This article was previously published under Q225907



This article applies only to a Microsoft Access database (.mdb).

Novice: Requires knowledge of the user interface on single-user computers.



SYMPTOMS
Users can edit AutoNumber fields that have their FieldSize property set to ReplicationID when these values are bound to data access pages.



RESOLUTION
In Design view of the page, right-click the control that is bound to the AutoNumber field, and then click Properties on the shortcut menu. In the property sheet, set either the Disabled or the ReadOnly property to True.



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 Behavior
 Open the sample database Northwind.mdb. In the Database window, click Tables under Objects, and then click the Shippers table. On the Edit menu, click Copy; on the Edit menu, click Paste. Save the table as tblTest, and then click OK. Open the tblTest table in Design view.</li>  For the ShipperID field, change the FieldSize property from Long Integer to Replication ID. Click Yes when you receive the following message: <pre class="fixed_text">  Once you save the change to the data type of this column, you will not be able to change back to the previous data type.

Are you sure you want change the data type? </li> Save and close the table.</li> In the Database window, click Pages under Objects, and then click New.</li> In the New Data Access Page box, click AutoPage: Columnar, click tblTest in the Choose the table or query where the object's data comes from box, and then click OK.</li> In Page view of the new page, change the value of the ShipperID field in record 1 from {00000001-0000-0000-0000-000000000000} to {00000004-0000-0000-0000-000000000000}.</li> Move to record 2 and then back to record 1. Note that the ShipperID for the first record has been updated.

NOTE: If, however, the ShipperID were related to a ShipperID in another table, and that relationship enforced referential integrity, this update would not have been possible if the ReplicationID existed in both tables, unless Cascade Update was in effect.</li> Click the New Record button on the Record Navigation bar.</li>  Type the following values: <pre class="fixed_text">  ShipperID: {00000005-0000-0000-0000-000000000000} CompanyName: My Company Phone: 555-1212 </li> Click the Save Record button on the Record Navigation bar.</li> Close the page (saving the page is optional) and open the tblTest table in Datasheet view to confirm that all of the data changes have been saved.</li></ol>

Additional query words: pra

Keywords: kbbug kbnofix kbdap KB225907

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.