Modifying Data in a View

With a few exceptions, the results of views are updateable. Recognize that a view is not a table and does not contain any data. Therefore, when you are modifying the data in a view, you are modifying the underlying table. You cannot violate any rules, check constraints, referential integrity rules, or any other rules that govern the data that can be contained in the tables. The following are limitations to the updateability of a view:

  • If a view joins multiple tables, you can insert and update data in only one table at a time in the view result.

  • The results of a view that aggregates data are not updateable.

  • The results of a view that unions data without the UNION ALL clause are not updateable.

  • The results of a view that contains ...

Get Alison Balter's Mastering Access 2002 Enterprise Development now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.