怎样一次删除数据库中的多条记录？

我想一次删除数据库中的多条满足条件的记录，不知怎么写，还请大家帮帮忙.
比如我想删除数据库a.mdb中表b的条件满足type="电影"的所有记录
---------------------------------------------------------------

"delete from b Where type='电影'"
---------------------------------------------------------------

delete from b where type="电影"
---------------------------------------------------------------

"delete from [b] Where type='电影'"
---------------------------------------------------------------

curDir = Server.MapPath("user.mdb")
set conn=server.createobject("adodb.connection")
conn.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & curDir
sql="delete from b Where type='电影'"
conn.Execute(sql)
conn.Close
set conn=nothing

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

1   
2exec="select * from 表名 where typt="电影"   
3set rs=server.createobject("adodb.recordset")   
4rs.open exec,conn,3,3   

1   
2while not rs.eof   
3rs.delete   
4rs.movenext   
5wend