In my database I have 2 tables, one of which is linked to a SQL Server. I pull data from the SQL Linked table to an intermediate table (to prevent ANY possibility of data being written back to the SQL Table or being modified) via a SQL Query, and dump it into my working table. This data is basically test results for a Motor. I then run a SQL Query that scans this intermediate table for a Serial Number that I am scanning on the completed motor to see if that Serial Number has test results available on the SQL Server. If the Serial Number from the scanned Motor is found in the SQL Test Results table, the Test Data is transferred to a Results table that lets the operator know it's OK to pack the motor and ship it since it passed the functional test and data is available. The problem I'm seeing is that about once a day the data transfer seems to hang up, but not the data transfer from the SQL Server to the Intermediate Table, but from the Intermediate Table to the Results table. We scan in 18 Motors for a shipment, and invariably, I'll get 1 or 2 that won't get transferred to the Results table when I run that SQL Query checking the Source Table for Test Data. I can then open the Source Table (both the linked SQL Table and the intermediate working table) and see that the results are there, and available, but for some reason, my SQL Query that is checking for the faulty Serial Number is not "seeing" that data, so it's telling me that these 1 or 2 units are missing test data. Now, if I close Access and restart, or delete the "bad" units and rescan them 15 minutes later for example, the SQL Query will then see the test data and transfer the data to the Results table. I have no clue where to look.