请朋友告诉我一下谢谢大家啊我急用啊

[xinshou1979330]

<%
Name=request.form("Name")
Email=request.form("Email")
Message=request.form("Message")
application.lock
set dsconn2=server.createobject("ADODB.Connection")
dsconn2.open "Driver={Microsoft Access Driver (*.mdb)};DBQ="&server.mappath("mine.mdb")
sql="insert into Information (Name,Email,Message) values('"&Name&"','"&Email&"','"&Message&"')"
dsconn2.execute(sql)
dsconn.close
application.unlock
response.redirect("messageboard.asp")
%>
为什么会这样啊?请朋友告诉我一下该怎么改好?谢谢
错误类型：
Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
[Microsoft][ODBC Microsoft Access Driver] 字段 'Information.Name' 不能是零长度的字符串。
/savewritting.asp, 第19 行

[xpk]

数据库设计得问题，可以将该字段设置允许为空。

[alexgeng]

数据库的问题。。允许为空

[xinshou1979330]

<%
Name=request.form("Name")
Email=request.form("Email")
Message=request.form("Message")
application.lock
set dsconn=server.createobject("ADODB.Connection")
dsconn.open "Driver={Microsoft Access Driver (*.mdb)};DBQ="&server.mappath("mine.mdb")
sql="insert into Information (Name,Email,Message) values('"&Name&"','"&Email&"','"&Message&"')"
dsconn.execute(sql)
dsconn.close
application.unlock
response.redirect("messageboard.asp")
%>
这是程序段想存储到数据库但出现的却是:
Message_Board

--------------------------------------------------------------------------------

Message_Count:9Page_Count:2[1][2]UPPAGEDOWNPAGE


--------------------------------------------------------------------------------

I want to write:
Name:E_Mail:Time;
Message;


--------------------------------------------------------------------------------
Name:E_Mail:Time;
Message;


--------------------------------------------------------------------------------
Name:E_Mail:Time;
Message;


--------------------------------------------------------------------------------
Name:E_Mail:Time;
Message;


--------------------------------------------------------------------------------
Name:E_Mail:Time;
Message;


--------------------------------------------------------------------------------
Name:E_Mail:Time;
Message;


--------------------------------------------------------------------------------
I want to write:
这样的为什么啊?请告诉我一下啊