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

ID: Q225907


The information in this article applies to:

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 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:


  7. 
       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? 
  8. Save and close the table.


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


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


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


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


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


  14. Type the following values:


  15. 
       ShipperID: {00000005-0000-0000-0000-000000000000}
       CompanyName: My Company
       Phone: 555-1212 
  16. Click the Save Record button on the Record Navigation bar.


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

Last Reviewed: July 19, 1999