queries not updatable

L

larpup

I have some underlying queries (of forms) that are not updateable. Can
someone shed some light as to what makes a query not updateable? A
little confused here.

Any advice is appreciated.

Regards,

Lar
 
D

Duane Hookom

This is usually because some joins aren't based on primary and foreign keys.
You may also have a group by somewhere in your query. Try this KB link
http://support.microsoft.com/?kbid=328828 and if it doesn't help, come back
with the sql view of your query and a description of how your tables are
related.
 
V

Van T. Dinh

Queries that involve 2 or more Tables may not be updateable depending on how
the Tables are related in the Query.

Check Access Help topic "Updatable Queries" for more info. and a few
techniques to change a non-updateable Query to become updateable.
 
Top