469,925 Members | 1,519 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,925 developers. It's quick & easy.

Operation must use an updateable query.

Hello Sir/ Madam
i am suresh today i am joined this community. please help me. i have installed WindowsXp, Internet Information Services 5.1 (IIS) this IIS and Microsoft Access 2003 installed. olny read the database value but not insert and update the value in database. what is the problem?.i don't know. please help me.
Expand|Select|Wrap|Line Numbers
  1. set con=server.CreateObject("adodb.connection")
  2. set rs=server.CreateObject("adodb.recordset")
  3. con.open "provider=microsoft.jet.oledb.4.0; data source="&server.MapPath("..\DataBase\suresh.mdb")
  4.  
  5. addRec="Insert into PrayerCircular(prayermessage) values('"&prayermessage&"')"
  6.  
  7. con.execute addRec
'------------------error type---------------------
Error Type:
Microsoft JET Database Engine (0x80004005)
Operation must use an updateable query.
---------------------------------------------------

this is error display please help me.

by
suresh
Oct 3 '07 #1
1 2026
jhardman
3,406 Expert 2GB
Suresh,

I believe that you need a space after "PrayerCircular" and "values". Your example uses a syntax as if calling a function in a programming language, but SQL is structured to be almost readable English. It needs spaces after keywords.

I am not sure this will clear up the problem, I usually use "addNew" rather than "insert" which requires different syntax. If you would like, I will give my code snippet for an equivalent outcome.

Jared
Oct 4 '07 #2

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

6 posts views Thread by ano1optimist | last post: by
8 posts views Thread by Jim in Arizona | last post: by
11 posts views Thread by Arpan | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.