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

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.