Hi all,

  Good day.



  I was trying to insert a record into an Access database from an ASP 

page, the inserting failed and gave me such ASP error.



  *Operation must use an updatable query.



  This is my work at home and now I'm in office, so I can't provide the 

error code and the whole error message.



  I appreciate your helpful advise, thank you.



Regards,

Mike Yeap

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

From: "Mike Yeap" <wkk1020@g...>

Subject: [access_asp] Error occured during record inserting.





:   I was trying to insert a record into an Access database from an ASP

: page, the inserting failed and gave me such ASP error.

:

:   *Operation must use an updatable query.

:

:   This is my work at home and now I'm in office, so I can't provide the

: error code and the whole error message.

:

:   I appreciate your helpful advise, thank you.



~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~



Mike,



The error is probably being caused by either:

a) a malformed query (ie its not valid SQL)

b) a permissions problem



That said, without seeing:

a) the code you are using

b) the way you have your system setup

we can't really help much. Is it that much to ask that you cut-n-paste the

error message and your code and save it onto a disk, and bring your disk to

work (or email it to work), and then post it here?



A little effort on your part makes it easier for us to help you:

<quote>

When someone posts a message with a lot of supporting info and says, "I

looked here, I tried this, I obtained this result, but I'm stuck here", it

is very easy to take the time and help this person out, even if you don't

have the answer right at the tip of your tongue. For that matter, it is

easier to provide the right answer when all the details are laid out like

this. [1]

</quote>



Cheers

Ken



[1] www.adopenstatic.com/personal/help.asp

This error is caused by the anonymous internet user not having write 

access within the directory that the database resides.  If your hosting 

through an ISP then gaining write access for the anonymous user should be 

documented within their support section.  If you are doing it on your own 

server then you need to go into permissions for that directory and give 

the anonymous user write access AND go into the IIS admin and provide 

write access within that directory.



Good luck,



Raymond



> Hi all,

>   Good day.

> 

>   I was trying to insert a record into an Access database from an ASP 

> page, the inserting failed and gave me such ASP error.

> 

>   *Operation must use an updatable query.

> 

>   This is my work at home and now I'm in office, so I can't provide the 

> error code and the whole error message.

> 

>   I appreciate your helpful advise, thank you.

> 

> Regards,

> Mike Yeap