菜鸟级ACCESS连接问题
hero 2000-05-14 02:43:00 如果这样写正确执行:
set conn=server.createobject("adodb.connection")
set rs0=server.createobject("adodb.recordset")
conn.open "driver={Microsoft Access Driver (*.mdb)};
dbq=" & server.mappath("chat.mdb")
conn.execute "Select * from chatsay"
把最后一句改为:
conn.execute "Delete * from chatsay"
或者INSERT语句,则出错,我少了什么配置吗?
另外,下一句出错:
rs0.open "select * from chatsay" ,conn,adOpenDynamic ,adLockOptimistic
提示参数配置不兼容!