Interactions Among Query and View Designer Windows

When you design a view, the View Designer retains your work in memory.  That is, the View Designer does not transmit your work to the database until you explicitly save the view there.  For each open Query Designer and View Designer Window, the Visual Database Tools retain a separate portion of memory to retain your work.  Because each window has its own memory, the modifications you make in one window are not available to any other window. 

Remember, you can use a view as part of a query or as part of another view. After you modify a view, your modifications will not affect queries or other views until you save the modified view to the database.

Note   Database diagrams and Table Designer windows use a different strategy to retain your work in memory.  For more information, see Interactions Among Database Diagrams and Table Design Windows.

See Also

Interactions Among Database Diagrams and Table Design Windows