vad är felet...
Fattar inte!
Kod:
<%
dim Connect
dim rs
dim SQL
Set Connect = Server.CreateObject("ADODB.Connection")
Connect.Open "Driver={Microsoft Access Driver (*.mdb)};Dbq=page1.mdb;DefaultDir=d:\xxx\xxx\page1;Uid=Admin;Pwd=;"
Set rs = Server.CreateObject("ADODB.RecordSet")
SQL = "SELECT * FROM table WHERE 1=2"
rs.open SQL, Connect, 1, 2
rs.Addnew
rs("header") = myHeader
rs("ingress") = myIngress
rs("text") = myText
rs("created") = myEditDate
rs("edited") = myEditDate
rs("placedleft") = False
rs.Update
rs.Close
%>
Felmeddelande:
Microsoft OLE DB Provider for ODBC Drivers error '80040e14'
[Microsoft][ODBC Microsoft Access Driver] Syntax error in FROM clause.
/total/test/skrivut.asp, line 118
Tack på förhand