queries not updatable

  • Thread starter Thread starter larpup
  • Start date Start date
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
 
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.
 
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.
 
Back
Top