Updatable query

  • Thread starter Thread starter GeorgeMar
  • Start date Start date
G

GeorgeMar

I know that having a query with two related tables is not
always updatable. But sometimes it does allow you to
update such a query.

Is there an easy way to determine when the query is or is
not updatable?

many thanks
george
 
I know that having a query with two related tables is not
always updatable. But sometimes it does allow you to
update such a query.

Is there an easy way to determine when the query is or is
not updatable?
Click to expand...

If the help message that explained this rather nicely in Access97 help
is still available, I can't find it. Grrrr....

Some issues that can prevent updateability:

- A joined query must have a unique Index (such as a Primary Key) on
the "one" side joining field, and a nonunique Index on the foreign
key. Defining a relationship will create such an index so don't do it
twice.

- Any Totals operation - Group By, Count, Sum, etc. - anywhere in a
Query will block updating.

- Setting the query's Unique Values property (SELECT DISTINCT in SQL)
will block updating.

- Union queries or Crosstab queries can never be updateable.
 
Thank you John
-----Original Message-----


If the help message that explained this rather nicely in Access97 help
is still available, I can't find it. Grrrr....

Some issues that can prevent updateability:

- A joined query must have a unique Index (such as a Primary Key) on
the "one" side joining field, and a nonunique Index on the foreign
key. Defining a relationship will create such an index so don't do it
twice.

- Any Totals operation - Group By, Count, Sum, etc. - anywhere in a
Query will block updating.

- Setting the query's Unique Values property (SELECT DISTINCT in SQL)
will block updating.

- Union queries or Crosstab queries can never be updateable.


.
Click to expand...
 
Back
Top