Insert error :: must be updateable?

[jason]

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

[Ray at]

[url]www.aspfaq.com[/url]

Ray at work

"jason" <jason@catamaranco.com> wrote in message
news:%23n3kmoWTDHA.2152@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
>
>

[Ray at]

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%>" <ask@me.forit> wrote in message
news:eJDvvxWTDHA.2120@TK2MSFTNGP10.phx.gbl...

> [url]www.aspfaq.com[/url]
>
> Ray at work
>
> "jason" <jason@catamaranco.com> wrote in message
> news:%23n3kmoWTDHA.2152@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
> >
> >

>
>

[jason]

I inherited an entire backend from the previous developers and I am just
trying to stay afloat while moving servers :)) - Thanks!
"Aaron Bertrand - MVP" <aaron@TRASHaspfaq.com> wrote in message
news:OGmbl9WTDHA.3636@tk2msftngp13.phx.gbl...

> > Microsoft JET Database Engine error '80004005' Operation must use an
> > updateable query./admin/news1.asp, line 59

>
> [url]http://www.aspfaq.com/2062[/url]
> [url]http://www.aspfaq.com/2009[/url]
>

> > Set rsnews = data.execute(sql1)
> > Set rsnews = Nothing

>
> Why are you using a recordset to execute a DELETE query?
>
> [url]http://www.aspfaq.com/2191[/url]
>
>