Snitz Forums 2000 - "Must use an updatable query"?

Snitz Forums 2000

Username:	Password:
Save Password
Forgot your Password?

All Forums

Help Groups for Snitz Forums 2000 Users

Help: General / Classic ASP versions(v3.4.XX)

"Must use an updatable query"?

New Topic

Topic Locked

Printer Friendly

Author

Topic

mkelley
Junior Member

112 Posts

Posted - 10 February 2005 : 06:20:20

My forum has been screwed up by my host and in an effort to get things right they have done something now so I can actually *get* to the front page (not so good before). However, now I get this:

"Microsoft JET Database Engine error '80004005'

Operation must use an updateable query.

/forum/inc_func_common.asp, line 675"

At that line is the function:

"function UpdateLastHereDate(fTime,UserName)
'## Forum_SQL - Do DB Update
strSql = "UPDATE " & strMemberTablePrefix & "MEMBERS "
strSql = strSql & " SET M_LASTHEREDATE = '" & fTime & "'"
strSql = strSql & ", M_LAST_IP = '" & Request.ServerVariables("REMOTE_ADDR") & "'"
strSql = strSql & " WHERE " & strDBNTSQLName & " = '" & ChkString(UserName, "SQLString") & "' "
my_conn.Execute (strSql),,adCmdText + adExecuteNoRecords
end function"

which is all plain vanilla Snitz. Can anyone give me even a clue as to what's going on here and what I need to do next to get my forum (which has been working nearly a year without changes) up and running again?

If you want to look it's at http://www.composeforums.com

Shaggy
Support Moderator

Ireland
6780 Posts

Posted - 10 February 2005 : 06:55:10

Try searching these forums for that error; it's come up many, many times before.

Search is your friend
“I was having a mildly paranoid day, mostly due to the
fact that the mad priest lady from over the river had
taken to nailing weasels to my front door again.”