469,352 Members | 1,661 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

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

Insert error :: must be updateable?

I am picking up the following error message which is strange as it has only
started happening since I have transferred servers:
Microsoft JET Database Engine error '80004005' Operation must use an
updateable query./admin/news1.asp, line 59
sql1 = "INSERT INTO [News]
(strDate,Department,Title,ShortDescription,strCont ent) VALUES (" & strDate1
& ",'" & strDepartment1 & "','" & strNewsTitle1 & "','" &
strShortDescription1 & "','" & strDescription1 & "')" Set rsnews =
data.execute(sql1) Set rsnews = Nothing
Jul 19 '05 #1
3 1738
www.aspfaq.com

Ray at work

"jason" <ja***@catamaranco.com> wrote in message
news:%2****************@TK2MSFTNGP12.phx.gbl...
I am picking up the following error message which is strange as it has only started happening since I have transferred servers:
Microsoft JET Database Engine error '80004005' Operation must use an
updateable query./admin/news1.asp, line 59
sql1 = "INSERT INTO [News]
(strDate,Department,Title,ShortDescription,strCont ent) VALUES (" & strDate1 & ",'" & strDepartment1 & "','" & strNewsTitle1 & "','" &
strShortDescription1 & "','" & strDescription1 & "')" Set rsnews =
data.execute(sql1) Set rsnews = Nothing

Jul 19 '05 #2
Also, do not create a recordset when you delete. Just do

data.execute sql1
data.close
set data = nothing

Ray at work

"Ray at <%=sLocation%>" <as*@me.forit> wrote in message
news:eJ**************@TK2MSFTNGP10.phx.gbl...
www.aspfaq.com

Ray at work

"jason" <ja***@catamaranco.com> wrote in message
news:%2****************@TK2MSFTNGP12.phx.gbl...
I am picking up the following error message which is strange as it has

only
started happening since I have transferred servers:
Microsoft JET Database Engine error '80004005' Operation must use an
updateable query./admin/news1.asp, line 59
sql1 = "INSERT INTO [News]
(strDate,Department,Title,ShortDescription,strCont ent) VALUES (" &

strDate1
& ",'" & strDepartment1 & "','" & strNewsTitle1 & "','" &
strShortDescription1 & "','" & strDescription1 & "')" Set rsnews =
data.execute(sql1) Set rsnews = Nothing


Jul 19 '05 #3
I inherited an entire backend from the previous developers and I am just
trying to stay afloat while moving servers :)) - Thanks!
"Aaron Bertrand - MVP" <aa***@TRASHaspfaq.com> wrote in message
news:OG**************@tk2msftngp13.phx.gbl...
Microsoft JET Database Engine error '80004005' Operation must use an
updateable query./admin/news1.asp, line 59


http://www.aspfaq.com/2062
http://www.aspfaq.com/2009
Set rsnews = data.execute(sql1)
Set rsnews = Nothing


Why are you using a recordset to execute a DELETE query?

http://www.aspfaq.com/2191

Jul 19 '05 #4

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

2 posts views Thread by Mano kumar | last post: by
3 posts views Thread by Pravin A. Sable | last post: by
reply views Thread by Sharon | last post: by
7 posts views Thread by Larry B via DotNetMonster.com | last post: by
reply views Thread by zhoujie | last post: by
reply views Thread by suresh191 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.