ACC2000: Access Quits When You Add Data Through a Query After You Upgrade to Jet 4.0 Service Pack 5

   File name     Version      Size               
   ---------------------------------------
   Msjet40.dll   4.0.4431.1   1,503,504 bytes
   Msjet40.dll   4.0.4431.3   1,503,504 bytes  
				

Steps to Reproduce the Behavior

1. Create a new Access 2000 database.
2. Create the following table in Design view:

      Table: Table1
      ----------------------------
      Field Name: Ticket_ID
      Data Type: AutoNumber
      Indexed: Yes (No Duplicates)
   
      Field Name: TicketDate
      Data Type: Date/Time
   
      Table Properties: Table1
      -------------------------------
      PrimaryKey: Ticket_ID
   					

3. Save and close the table.
4. Create the following table in Design view:

      Table: Table2
      ----------------------------
      Field Name: TicketNumberID
      Data Type: AutoNumber
      Indexed: Yes (No Duplicates)
   
      Field Name: Ticket_ID
      Data Type: Number
      Indexed: Yes (Duplicates OK)
   
      Field Name:  TicketItemsDesription
      Data Type:  Text
   
      Table Properties: Table2
      -------------------------------
      PrimaryKey: TicketNumberID
   					

5. Save and close the Table.
6. Create the following table in Design view:

      Table: Table3
      ----------------------------
      Field Name: TicketItems_ID_Loc
      Data Type: Number
      Indexed: Yes (No Duplicates)
   
      Field Name: TicketItems_Location
      Data Type: Text
   
      Table Properties: Table3
      -------------------------------
      PrimaryKey: TicketItems_ID_Loc  
   					

7. Save and close the table.
8. On the Tools menu, click Relationships. Add Table1, Table2 and Table3 to the Relationships window, and then click Close.
9. Select the Ticket_ID field in the Table1 table and drag it to the Ticket_ID field in the Table2 table.
10. In the Edit Relationships window, click to select the Enforce Referential Integrity, Cascade Update Related Fields and Cascade Delete Related Records check boxes.
11. Click Create to close the Edit Relationships window.
12. Select the TicketNumberID field in the Table2 table and drag it to the TicketItems_ID_Loc field in the Table3 table.
13. In the Edit Relationships window, click to select the Enforce Referential Integrity, Cascade Update Related Fields and Cascade Delete Related Record options check boxes.
14. Click the Join Type button in the Edit Relationships window and select join type 2 in the Join Properties window.
15. Click OK in the Join Properties window, and then click Create in the Edit Relationships window.
16. Close the Relationships window, and then save the changes.
17. Create the following query in Design view:

       Query: MyTables
       ------------------------------
       Type: Select Query
    
       Field: Ticket_ID
       Table: Table1
    
       Field: TicketDate
       Table: Table1
    
       Field: TicketNumberID
       Table: Table2
    
       Field: Ticket_ID
       Table: Table2
    
       Field: TicketItemsDescription
       Table: Table2
    
       Field: TicketItems_ID_Loc
       Table: Table3
    
       Field: TicketItems_Locations
       Table: Table3
    					

18. Run the MyTables query.
19. Try to add a new record in the datasheet. After you add data to the first field from the Table2 table and try to move to the next field, note that you receive one of the errors that is mentioned in the "Symptoms" section of this article.