SQL Update, Insert and Delete

Ask a Question related to ASP Database, Design and Development.

  1. #1

    Default SQL Update, Insert and Delete

    Why do I get the message "Operation must use an updateable
    query" on an Update, Insert and Delete. Mind you the site
    worked fine before a recent re-install of IIS 5.0. I'm
    using an Access Database.
    Thanks
    Lou Guest

  2. Similar Questions and Discussions

    1. I need a View, Insert, Update, Delete paradigm for usingflash forms
      Flash forms are the greatest. But I'm struggling with a usable paradigm for handling all database functions with them. Most notably, since I can't...
    2. ASP/VBS Using Command to Insert/Update/Delete
      Hi, I would just like to know when/why etc would you command and if there any penalties in using the command. Thanks, Sanjay
    3. How to know if UPDATE, INSERT or DELETE succeed
      Hi, Suppose that, "Set Rs = cmd.Execute" perform a DELETE command. How can'I check if the command succeed without to requery the table seeking...
    4. OOP page: Where to put update, insert, delete
      I have a page that shows info from MySQL. It is for an online education site. It uses different classes arranged in a hierarchy. Each lesson is...
    5. Before update or delete trigger to insert ?
      Hi, I need some help...I'm fairly new to triggers and am attempting to duplicate a trigger in DB2 that already works in SQL Server. The basics...
  3. #2

    Default Re: SQL Update, Insert and Delete

    [url]http://www.aspfaq.com/2009[/url]
    [url]http://www.aspfaq.com/2062[/url]

    --
    [url]http://www.aspfaq.com/[/url]
    (Reverse address to reply.)




    "Lou" <lou_difalco@adp.com> wrote in message
    news:1fb8901c4588a$6f48a720$a301280a@phx.gbl...
    > Why do I get the message "Operation must use an updateable
    > query" on an Update, Insert and Delete. Mind you the site
    > worked fine before a recent re-install of IIS 5.0. I'm
    > using an Access Database.
    > Thanks

    Aaron [SQL Server MVP] Guest

Posting Permissions

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

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139