>>>We are using Visual FoxPro 5.0 to create a framework. We are now making a security-form and we want to use a grid with a view instead of multible tables. Now we would like to know if it is possible to use a view in a multi user environment so that more than one person can access and change the data without getting any errors.
>
>>View is always local, i.e. every user will get own one in run-time.
>
>Thank you for your answer.
>We have to choose now between using tables or views. Can you tell us de advantages and disadvantages of using views instead of tables in a multi user environment?
>
>
>Afier Appelman
>Using the account of Koos Veel
There are no specific advantages in regard to multiuser environment. Generally speaking, views allow to provide multi-record save/cancel at once fuctionality better than tables, but tables provide faster interface. Normally, application uses both tables and views depends on current form requirements.
Edward Pikman
Independent Consultant