>After altering table when I try to open view an error message is generated. is there a way to alter the view also or to do something else?
This should on;y happen if the view uses SELECT *. If you name the field explicitly, and fields used are still in the table, you shouldn't have a problem.
Erik Moore
Clientelligence