Record Set Not Updatable

[DBFIN]

I have QUERY A that is based on a join between QUERY B and a TABLE 1. The join matchs the following fields from both QUERY B AND TABLE 1 : transdate, custid and item. The query works fine without any criteria. However if I add the criteria that these three fields from TABLE 1 be null, the query results with an error message: "Record set not updatable." Do you know what's causing this and how I can eliminate the error ?

 

[boblarson]

See if anything here fits:

http://allenbrowne.com/ser-61.html

 

[DBFIN]

I'm reviewing the information you provided and testing the various issues that were referenced. I'll let you know the results of my testing.

 

[DBFIN]

I tested all the scenerios that seemed to apply. TABLE 1 is linked to a table in another database, which means TABLE 1 is read only. QUERY B accesses fields from TABLE 1, consequently QUERY B is a stacked read only query.

The information you provided solved the problem. Thank you very kindly.

 

[boblarson]