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

• Microsoft Access 2000

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 this to be a problem in the Microsoft products listed at the beginning of this article.

MORE INFORMATION

Steps to Reproduce Behavior

1. Open the sample database Northwind.mdb.



2. In the Database window, click Tables under Objects, and then click the Shippers table.



3. On the Edit menu, click Copy; on the Edit menu, click Paste.



4. Save the table as tblTest, and then click OK.



5. Open the tblTest table in Design view.



6. For the ShipperID field, change the FieldSize property from Long Integer to Replication ID. Click Yes when you receive the following message:




   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? 

7. Save and close the table.



8. In the Database window, click Pages under Objects, and then click New.



9. 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.



10. 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}.



11. 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.



12. Click the New Record button on the Record Navigation bar.



13. Type the following values:




   ShipperID: {00000005-0000-0000-0000-000000000000}
   CompanyName: My Company
   Phone: 555-1212 

14. Click the Save Record button on the Record Navigation bar.



15. 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.

Additional query words: pra

Keywords : kbdta AccDAP DAPProb
Version : WINDOWS:2000
Platform : WINDOWS
Issue type : kbbug