Operation must use an updateable query.

[sureshkmsc]

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.

set con=server.CreateObject("adodb.connection")
set rs=server.CreateObject("adodb.recordset")
con.open "provider=microsoft.jet.oledb.4.0; data source="&server.MapPath("..\DataBase\suresh.mdb")
 
addRec="Insert into PrayerCircular(prayermessage) values('"&prayermessage&"')"
 
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

[jhardman]

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