Frågan#1
va betyder
Microsoft OLE DB Provider for ODBC Drivers error '80040e14'
[Microsoft][ODBC Microsoft Access Driver] The SELECT statement includes a reserved word or an argument name that is misspelled or missing, or the punctuation is incorrect.
/spelat.asp, line 5
va för nåt som inte e bra?
här e lite kod oxå
<% Set Connect = Server.CreateObject("ADODB.connection")
Connect.open = "Driver={Microsoft Access Driver (*.mdb)}; DBQ=" & Server.MapPath("db/spelat.mdb")
VISA = "SELECT TOP 6* FROM spelat ORDER by date DESC "
Set RecSet = Connect.execute(VISA)
%>
<table width="382" border="0" cellspacing="0" cellpadding="0" height="20">
<tr>
<td width="22" align="left" valign="top"><font face="Verdana, Arial, Helvetica, sans-serif" size="1">
<% do until RecSet.EOF %>
</font>
<table width="354" border="0" cellspacing="0" cellpadding="0" height="19">
<tr>
<td width="200"><font face="Verdana, Arial, Helvetica, sans-serif" size="1">
<%=RecSet("date")%> / <%=RecSet("lag1")%> - <%=RecSet("lag2")%></font></td>
<td width="67"><font face="Verdana, Arial, Helvetica, sans-serif" size="1"><%=RecSet("re1")%>
-<%=RecSet("re2")%></font></td>
<td width="87"><font face="Verdana, Arial, Helvetica, sans-serif" size="1">Kl:
<%=RecSet("matchtid")%></font></td>
<% RecSet.MoveNext
loop
RecSet.close
Connect.close
Set RecSet = nothing
Set Connect = nothing %>
</tr>
</table>
<font face="Verdana, Arial, Helvetica, sans-serif" size="1"> </font></td>
</tr>
</table>
<font face="Verdana, Arial, Helvetica, sans-serif" size="1"> </font><font face="Verdana, Arial, Helvetica, sans-serif" size="1">
</font> <font face="Verdana, Arial, Helvetica, sans-serif" size="1"> </font><font face="Verdana, Arial, Helvetica, sans-serif" size="1">
</font>
<p>