conn.execute("insert into userfile(userid,password,email,cre_date) values('"&userid&"','"&password&"','"&email&"',getdate())")
------------------------------------------------------------------------------------
把password加上分隔符[password]试试:
conn.execute("insert into userfile(userid,[password],email,cre_date) values('"&userid&"','"&password&"','"&email&"',getdate())")