Updatable query

[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

 

[John Vinson]

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?

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.

 

[GeorgeMar]

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.


.