Operation must use an updateable query

asp.net United States
  • 18 years ago

    Why do I get this:
    "Operation must use an updateable query"
    when I am trying to Add records to a Microsoft Access database using "INSERT INTO " in .aspx page?


    Please help me
    Thanks
    Daniel

  • 18 years ago

    you've probably not given IUSR_MachineName read/write permissions on the Access database

  • 18 years ago

    Thanks James  


    I found that we need to get more power to the "aspnet_wp" account.
    If you let it limited as default it doesn't work.


    Thanks again
    Daniel

Post a reply

Enter your message below

Sign in or Join us (it's free).

Contribute

Why not write for us? Or you could submit an event or a user group in your area. Alternatively just tell us what you think!

Our tools

We've got automatic conversion tools to convert C# to VB.NET, VB.NET to C#. Also you can compress javascript and compress css and generate sql connection strings.

“Programming today is a race between software engineers striving to build bigger and better idiot-proof programs, and the Universe trying to produce bigger and better idiots. So far, the Universe is winning.” - Rich Cook