Marcelo Velasquez
Apr 22nd, 2000, 12:21 AM
If I build a View in a database, when the tables View are updated it is also updated?
Mongo
Apr 23rd, 2000, 05:48 AM
Keep in mind that Oracle, Sybase, Visual FoxPro, MS SQL Server or MS Access2000 data access pages for secured MS Access/MS Data Engine (MSDE) database views are different; in general, when you have granted applicable permissions to perform select, insert, update and delete operations on a single table view and modify an updateable recordset of that view, you are modifying the table. Whether or not the end-user "sees" the modification instantaneously depends upon the object/method you use to present the data. Hopefully, that's not too vague an answer to your general question.
pardede
Apr 24th, 2000, 05:57 AM
My experience with Access: if you built the view from tables that has 1-1 relationships with each other then the view is editable, if 1-many it's read-only