Results 1 to 2 of 2

Thread: Error Update

  1. #1
    Join Date
    Sep 2005

    Unanswered: Error Update


    I create the View which consist of multiple same table. When I want to update via the View, it doesn't allow me to update it, it gave out the following message,
    View or function 'Table1' is not updatable because the modification affects multiple base tables.

  2. #2
    Join Date
    Mar 2003
    The Bottom of The Barrel
    Provided Answers: 1
    What do you mean by "multiple same table"? If you're saying the view has self-joins, then the view is not going to be updatable.
    oh yeah... documentation... I have heard of that.

    *** What Do You Want In The MS Access Forum? ***

Posting Permissions

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