T.G.K
Junior Member
 
Vietnam
347 Posts |
Posted - 10 December 2001 : 00:54:46
|
help me,
Technical Information (for support personnel)
Error Type: Microsoft OLE DB Provider for ODBC Drivers (0x80004005) [Microsoft][ODBC Microsoft Access Driver] Operation must use an updateable query. /forum/inc_functions.asp, line 717
And this is my Line 717:
'## Forum_SQL - Do DB Update strSql = "UPDATE " & strMemberTablePrefix & "MEMBERS " strSql = strSql & " SET M_LASTHEREDATE = '" & DateToStr(strForumTimeAdjust) & "'" strSql = strSql & ", M_LAST_IP = '" & Request.ServerVariables("REMOTE_ADDR") & "'" strSql = strSql & " WHERE " & strMemberTablePrefix & "MEMBERS." & strDBNTSQLName & " = '" & ChkString(UserName, "SQLString") & "' "
my_conn.Execute (strSql) <---this is 717
|
|
Davio
Development Team Member
    
Jamaica
12217 Posts |
Posted - 10 December 2001 : 01:18:17
|
Try doing a search for Operation must use an updateable query. or 80004005 here on the forums. Selecting the "Search exact phrase" and the Help forums, could narrow down your search also.
It's basically a permissions problem. The forum needs to write (or update) to the database, but it doesn't have permission to do so. So it gives you that error.
- David |
 |
|