What makes a query updateable?

  • Thread starter Thread starter Tom
  • Start date Start date
T

Tom

It has been claimed on this newsgroup that records
can be added to queries that are updateable.

Let us say that there is a table such as

1 a
2 c

and then another complex query to which records
cannot be added such as

a |calculated value|
b |calculated value|
c |calculated value|
d |calculated value|


Is it possible to join this table and query in a manner
Such that further records can be added to it?

For example I want a query that joins the above table
and query where one can add record

3 d

to the table.
 
If one of the datasources, e.g. your non-updatable query, is not updatable
then the query is likely to be non-updatable, AFAIK.

Check Access Help on "Updatable Queries" for a few techniques on how to
construct updatable Queries.

Also, experiment and you shall know ...

HTH
Van T. Dinh
 
Back
Top