Probleminha error '80040e14'

[Jão Bosco de barros 0]

Eaw galera do Forum, tudo na boa?

é o seguinte, aqui na agencia que eu trabalho tem uns sites antigos feitos em ASP. mas funcionam perfeitamente

até que um deles mudou para a localweb, aparecia um erro que foi resolvido junto com o suporte

mas agora tem um erro que eu acho que é na sintax do código, e preciso da ajuda de vocês já que não entendo muito de ASP

 

Erro:

Microsoft Access Database Engine error '80040e14'

 

Syntax error in INSERT INTO statement.

 

/gerenciador/admin_noticias_insert.asp, line 164

 

Código:

<%
' *** Logout the current user.
MM_Logout = CStr(Request.ServerVariables("URL")) & "?MM_Logoutnow=1"
If (CStr(Request("MM_Logoutnow")) = "1") Then
 Session.Contents.Remove("MM_Username")
 Session.Contents.Remove("MM_UserAuthorization")
 MM_logoutRedirectPage = "../index.asp"
 ' redirect with URL parameters (remove the "MM_Logoutnow" query param).
 if (MM_logoutRedirectPage = "") Then MM_logoutRedirectPage = CStr(Request.ServerVariables("URL"))
 If (InStr(1, UC_redirectPage, "?", vbTextCompare) = 0 And Request.QueryString <> "") Then
   MM_newQS = "?"
   For Each Item In Request.QueryString
     If (Item <> "MM_Logoutnow") Then
       If (Len(MM_newQS) > 1) Then MM_newQS = MM_newQS & "&"
       MM_newQS = MM_newQS & Item & "=" & Server.URLencode(Request.QueryString(Item))
     End If
   Next
   if (Len(MM_newQS) > 1) Then MM_logoutRedirectPage = MM_logoutRedirectPage & MM_newQS
 End If
 Response.Redirect(MM_logoutRedirectPage)
End If
%>
<%
dim include: include=1
     dim useTemplates: useTemplates=1
     dim useIntrospection: useIntrospection=1
     dim KT_display
%>
<!--#include file="conn_faeal.asp" -->
<%
' *** Restrict Access To Page: Grant or deny access to this page
MM_authorizedUsers=""
MM_authFailedURL="bccom.asp"
MM_grantAccess=false
If Session("MM_Username") <> "" Then
 If (true Or CStr(Session("MM_UserAuthorization"))="") Or _
        (InStr(1,MM_authorizedUsers,Session("MM_UserAuthorization"))>=1) Then
   MM_grantAccess = true
 End If
End If
If Not MM_grantAccess Then
 MM_qsChar = "?"
 If (InStr(1,MM_authFailedURL,"?") >= 1) Then MM_qsChar = "&"
 MM_referrer = Request.ServerVariables("URL")
 if (Len(Request.QueryString()) > 0) Then MM_referrer = MM_referrer & "?" & Request.QueryString()
 MM_authFailedURL = MM_authFailedURL & MM_qsChar & "accessdenied=" & Server.URLEncode(MM_referrer)
 Response.Redirect(MM_authFailedURL)
End If
%>
<%
' *** Edit Operations: declare variables

Dim MM_editAction
Dim MM_abortEdit
Dim MM_editQuery
Dim MM_editCmd

Dim MM_editConnection
Dim MM_editTable
Dim MM_editRedirectUrl
Dim MM_editColumn
Dim MM_recordId

Dim MM_fieldsStr
Dim MM_columnsStr
Dim MM_fields
Dim MM_columns
Dim MM_typeArray
Dim MM_formVal
Dim MM_delim
Dim MM_altVal
Dim MM_emptyVal
Dim MM_i

MM_editAction = CStr(Request.ServerVariables("SCRIPT_NAME"))
If (Request.QueryString <> "") Then
 MM_editAction = MM_editAction & "?" & Server.HTMLEncode(Request.QueryString)
End If

' boolean to abort record edit
MM_abortEdit = false

' query string to execute
MM_editQuery = ""
%>
<%
' *** Insert Record: set variables

If (CStr(Request("MM_insert")) = "frm_noticias_insert") Then

 MM_editConnection = MM_conn_faeal_STRING
 MM_editTable = "tbl_noticias"
 MM_editRedirectUrl = "admin_noticias_master.asp"
 MM_fieldsStr  = "data|value|tema|value|manchete|value|leading|value|texto|value|fonte|value|imagem|value|imagem_Alt|value|Destaque|value"
 MM_columnsStr = "data|',none,NULL|tema|',none,''|manchete|',none,''|leading|',none,''|texto|',none,''|fonte|',none,''|imagem|',none,''|imagem_Alt|',none,''|destaque|',none,''"

 ' create the MM_fields and MM_columns arrays
 MM_fields = Split(MM_fieldsStr, "|")
 MM_columns = Split(MM_columnsStr, "|")

 ' set the form values
 For MM_i = LBound(MM_fields) To UBound(MM_fields) Step 2
   MM_fields(MM_i+1) = CStr(Request.Form(MM_fields(MM_i)))
 Next

 ' append the query string to the redirect URL
 If (MM_editRedirectUrl <> "" And Request.QueryString <> "") Then
   If (InStr(1, MM_editRedirectUrl, "?", vbTextCompare) = 0 And Request.QueryString <> "") Then
     MM_editRedirectUrl = MM_editRedirectUrl & "?" & Request.QueryString
   Else
     MM_editRedirectUrl = MM_editRedirectUrl & "&" & Request.QueryString
   End If
 End If

End If
%>
<%
' *** Insert Record: construct a sql insert statement and execute it

Dim MM_tableValues
Dim MM_dbValues

If (CStr(Request("MM_insert")) <> "") Then

 ' create the sql insert statement
 MM_tableValues = ""
 MM_dbValues = ""
 For MM_i = LBound(MM_fields) To UBound(MM_fields) Step 2
   MM_formVal = MM_fields(MM_i+1)
   MM_typeArray = Split(MM_columns(MM_i+1),",")
   MM_delim = MM_typeArray(0)
   If (MM_delim = "none") Then MM_delim = ""
   MM_altVal = MM_typeArray(1)
   If (MM_altVal = "none") Then MM_altVal = ""
   MM_emptyVal = MM_typeArray(2)
   If (MM_emptyVal = "none") Then MM_emptyVal = ""
   If (MM_formVal = "") Then
     MM_formVal = MM_emptyVal
   Else
     If (MM_altVal <> "") Then
       MM_formVal = MM_altVal
     ElseIf (MM_delim = "'") Then  ' escape quotes
       MM_formVal = "'" & Replace(MM_formVal,"'","''") & "'"
     Else
       MM_formVal = MM_delim + MM_formVal + MM_delim
     End If
   End If
   If (MM_i <> LBound(MM_fields)) Then
     MM_tableValues = MM_tableValues & ","
     MM_dbValues = MM_dbValues & ","
   End If
   MM_tableValues = MM_tableValues & MM_columns(MM_i)
   MM_dbValues = MM_dbValues & MM_formVal
 Next
 MM_editQuery = "insert into " & MM_editTable & " (" & MM_tableValues & ") values (" & MM_dbValues & ")"

 If (Not MM_abortEdit) Then
   ' execute the insert
   Set MM_editCmd = Server.CreateObject("ADODB.Command")
   MM_editCmd.ActiveConnection = MM_editConnection
   MM_editCmd.CommandText = MM_editQuery
   MM_editCmd.Execute
   MM_editCmd.ActiveConnection.Close

   If (MM_editRedirectUrl <> "") Then
     Response.Redirect(MM_editRedirectUrl)
   End If
 End If

End If
%>

 

Arquivo de conexão(se for útil):

<%
session.timeout = 120
Set MM_conn_faeal_STRING = Server.CreateObject("ADODB.Connection")
	set rs=server.CreateObject("adodb.recordset") 
       MM_conn_faeal_STRING.Open "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=E:\home\faeal2\dados\faeal.mdb;Persist Security Info=False;"	 
       'SERVIDOR MM_conn_faeal_STRING.Open "DBQ=e:\home\faeal2\web\database\faeal.mdb;Driver={Microsoft Access Driver (*.mdb)}"	 

sub fecha_conexao
	 MM_conn_faeal_STRING.close
Set MM_conn_faeal_STRING =nothing
end sub
%> 

 

Valeu gente, Deus os abençoe!

[xanburzum 169]

Verifique a ortografia. pode ser um nome de coluna Invalido 'sua_coluna'. A coluna a qual você se refere na Base de Dados não foi encontrada. e também veja se os tipos de dados estão corretos