Operation must use an updateable query.

Discussion in 'Classic ASP' started by shoaib, Nov 22, 2008.

Thread Status:
Threads that have been inactive for 5 years or longer are closed to further replies. Please start a new thread.
  1. Hi,

    I have created a website by using Ms Access database. It runs successfully at localhost and Intranet. But after hosting at Discount ASP.net I can see the records but cannot Insert, update and delete any transaction from any table. I am not using FTP extensions as I don't want to disturb our existing website. I have uploded the webpages by FTP and my website link is http://www.deltabizz.com/iPhone/index.asp

    UserName = user1
    Password = user1

    Click on members and then click on Add Member. Type user5 and click on Add button. Error 'Operation must use an updateable query.' comes up. I have closed examined this error is coming at insert,update and delete operation. From microsoft reference, this is because of security issue. But I don't know how to give the rights for IUSR Internet guest account to read/write, as I don't have any option other than FTP or control panel. But I have gone through control panel I didn't find any option.

    Kindly help me to fix this problem.

    Regards,

    Shoaib
     
  2. Bruce

    Bruce DiscountASP.NET Staff

    this is usually related to inadequate permission to the access database file. Did you check to make sure the anonymous user have write permission to the folder containing the database file.


    Bruce

    DiscountASP.NET
    www.DiscountASP.NET
     
  3. Thanks Bruce,


    I have checked Write permission was Denied. I have done allow write permission.


    Thanks for your help


    Regards,
    Shoaib
     
Thread Status:
Threads that have been inactive for 5 years or longer are closed to further replies. Please start a new thread.

Share This Page