Conn.execute update 更新access时间三种方法总结:
方法一:
set rs1=Conn.execute("updata Cms_vip set [last]=now() where User='"&xm&"'")
方法二:
set rs1=Conn.execute("updata Cms_vip set [last]=#"&now()&"# where User='"&xm&"'")
方法三:
' set rs1=server.CreateObject("adodb.recordset")
' rs1.open"select last from cms_vip where user='"&xm&"'",conn,1,3
' rs1(0)=now()
' rs1.update()
' rs1.close
' set rs1=nothing