SQL indsæt i Access, ASP

www.biggel.com/asp/brugersys/opret.asp

Hvis man prøver at oprette for jeg følgende fejl:

Microsoft OLE DB Provider for ODBC Drivers error '80040e14'

[Microsoft][ODBC Microsoft Access Driver] Syntax error in INSERT INTO statement.

/asp/brugersys/save.asp, line 44




save.asp :
<%
' Databaseforbindelse - husk at angive sti til din database
Set Conn = Server.CreateObject("ADODB.Connection")
DSN = "DRIVER={Microsoft Access Driver (*.mdb)}; "
DSN = DSN & "DBQ=" & Server.MapPath("db.mdb")
Conn.Open DSN

' SQL sætning opbygges
strSQL = "Insert into brugere ("

strSQL = strSQL & "username, "
strSQL = strSQL & "password, "
strSQL = strSQL & "realname, "
strSQL = strSQL & "email, "
strSQL = strSQL & "beskriv, "
strSQL = strSQL & "msn, "
strSQL = strSQL & "icq, "
strSQL = strSQL & "date, "
strSQL = strSQL & "homepage) "

strSQL = strSQL & "values( "

strSQL = strSQL & "' " & request.form("username") &" ', "
strSQL = strSQL & "' " & request.form("password") &" ', "
strSQL = strSQL & "' " & request.form("realname") &" ', "
strSQL = strSQL & "' " & request.form("email") &" ', "
strSQL = strSQL & "' " & request.form("beskriv") &" ', "
strSQL = strSQL & "' " & request.form("msn") &" ', "
strSQL = strSQL & "' " & request.form("icq") &" ', "
strSQL = strSQL & "' " & request.form("date") &" ', "
strSQL = strSQL & "' " & request.form("homepage") &" ')"

' SQL sætning eksekveres
Conn.Execute(strSQL)

' Luk databaseforbindelse
Conn.Close
Set Conn = Nothing
%>






opret.asp :
<!-- Bror S. Skardhamar -->
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">

<html>
<head>
    <title>Untitled</title>
</head>

<body>

<form action="save.asp?save=opretbruger" method="post">

<table>
<tr>
    <td>Bruger navn</td>
    <td>:</td>
    <td><input name="username" type="Text"></td>
</tr>
<tr>
    <td>Password</td>
    <td>:</td>
    <td><input name="password" type="Text"></td>
</tr>
<tr>
    <td>Rigtige navn</td>
    <td>:</td>
    <td><input name="realname" type="Text"></td>
</tr>
<tr>
    <td>E-mail</td>
    <td>:</td>
    <td><input name="email" type="Text"></td>
</tr>
<tr>
    <td>MSN Messenger</td>
    <td>:</td>
    <td><input name="msn" type="Text"></td>
</tr>
<tr>
    <td>ICQ</td>
    <td>:</td>
    <td><input name="icq" type="Text"></td>
</tr>
<tr>
    <td>Hjemmeside</td>
    <td>:</td>
    <td><input name="homepage" type="Text"></td>
</tr>
<tr>
    <td>Beskrivelse</td>
    <td>:</td>
    <td><input name="beskriv" type="Text"></td>
</tr>
<tr>
    <td></td>
    <td></td>
    <td align="right"><input value="Opret bruger" type="submit"></td>
</tr>
</table>


<input name="date" type="Hidden" value="<%= now %>">
</form>
</body>
</html>





Hvad er problemet?