急啊，帮我看看，是什么问题！

[wangasp]

这段删除数据库计录的代码错在哪啊？？？
names=request.form("name")
Set conn = Server.CreateObject("ADODB.Connection")
conn.Open "driver={Microsoft Access Driver (*.mdb)};dbq="&Server.MapPath("guest.mdb")
sql = "delete from ms where name="&names
conn.Execute(sql)
真搞不明白，搞了很久，大家帮个忙，看到底哪个地方有问题

[yifan268]

sql = "delete ???? from ms where name="&names

[hbhbhbhbhb1021]

sql = "delete from ms where name='" & names & "'"
试试

[menrock]

NAME是字符型的话同楼上,还有name是关键字,最好写成[name]

[yongz_0]

access?
sql = "delete * from ms where [name]="&names
or
sql = "delete * from ms where [name]='" & names & "'"

[winstarr]

sql = "delete from ms where name='" & names & "'"

[lstup]

names少了'
不是数字型，一定要用'括起来