H hermie Oct 7, 2004 #1 I have a strange problem now, some queries which I open cannot be edited and other can? What can cause this problem? herman
I have a strange problem now, some queries which I open cannot be edited and other can? What can cause this problem? herman
V Van T. Dinh Oct 8, 2004 #2 1. Queries that are based on 2 or more Tables may not be updateable depending on the joins you use. 2. Totals Queries are not updateable. 3. If the RecordsetType of the Query is "Snapshot", the Query is not updateable. 4. There are other reasons for a Query to be non-updateable.
1. Queries that are based on 2 or more Tables may not be updateable depending on the joins you use. 2. Totals Queries are not updateable. 3. If the RecordsetType of the Query is "Snapshot", the Query is not updateable. 4. There are other reasons for a Query to be non-updateable.
