sql用

conn.execute("update Product_Info set lastdate='"&now()&"' where id is not null")

access用
conn.execute("update Product_Info set lastdate=#"&now()&"#  where id is not null")