Query has become non updateable!

[GPM4663]

Have a query based on two other queries. This query is non-updateable even though the two it is based on are updateable. This has only happened recently and is I think the result of someone putting in some goofy data. However I'm having trouble trying to track down the strange data. I did a unmatched query for the linked fields in the query to see if that was it but have had no luck. I should be able to edit the data but can't. Does anyone have any ideas how I can track down the data or if my problem could be the result of something else? Many thanks

 

[JonFer]

Please post the SQL for the two queries and indicate the relationship (1-many, many-many, etc) between the underlying tables. What indexes are on the tables?

John

http://www.interautomateconsulting.com

 

[SQLSister]

Go to access help and search "query updateable", you will find the rules on what makes a query updateable or not updateable.

Questions about posting. See faq183-874

 

[JonFer]

SQLSister - In the help, I only saw one cause mentioned related to this error (an aggregate field). There are several other factors that are not discussed. Did you see other information about this topic? The UniqueRecords/UniqueValues parameters are important as are indexes.



John

http://www.interautomateconsulting.com

 

[PHV]

Have a query based on two other queries
Please post the 3 sql code.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[GPM4663]

Thanks everyone for you input. Have discovered that someone had removed the primary key from one of my tables (not deleted the autonumber but just "switched off" the primary key) so my relationships were no longer the same (referential integrity denied). Thanks for all the advice though!