Results 1 to 3 of 3

Thread: building as view

  1. Apr 22nd, 2000, 12:21 AM #1
    Marcelo Velasquez
    Marcelo Velasquez is offline

    Thread Starter
    Lively Member
    Join Date
    Jan 2000
    Location
    Sao Paulo - SP - BRAZIL
    Posts
    65

    Question

    If I build a View in a database, when the tables View are updated it is also updated?
    The blessing of God enriches and it doesn't increase pains
    Reply With Quote Reply With Quote
  2. Apr 23rd, 2000, 05:48 AM #2
    Mongo
    Mongo is offline
    Hyperactive Member
    Join Date
    Nov 1999
    Location
    Leavenworth KS USA
    Posts
    482
    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.

    Reply With Quote Reply With Quote
  3. Apr 24th, 2000, 05:57 AM #3
    pardede
    pardede is offline
    Addicted Member pardede's Avatar
    Join Date
    Jan 2000
    Posts
    232
    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
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules


Click Here to Expand Forum to Full Width