我这代码想批量执行sql语句来修改数据库，执行后没有提示，但数据没有修改


<%connstr="Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" &

server.MapPath("/database/sdf12312.mdb") & ";Persist Security

Info=False"
Set conn=Server.CreateObject("ADODB.CONNECTION")
conn.open connstr
conn.execute("update PE_Soft set ClassID=441 where ClassID=78 and

(softname like '*半期*' or softname like '*期中*')")
conn.execute("update PE_Soft set ClassID=442 where ClassID=79 and

(softname like '*半期*' or softname like '*期中*')")
%>

帮我做一份完整的，谢谢！！！

[此贴子已经被作者于2006-4-21 12:16:02编辑过]

connstr="Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & server.MapPath("/database/sdf12312.mdb") & ";Persist Security Info=False"
Set conn=Server.CreateObject("ADODB.CONNECTION")
conn.open conn

详细点，我才开始学
最好帮我弄好。谢谢！