老问题了,自己解决不了,求助大家!
sql   =   "insert   into   buy_together_ds(cp_num,pro_type,lottery_type,pro_title,pro_explain,pro_num,all_cost,share,share_cost,pro_user,share_take,schedule,pro_state,pro_upload,take,take_share,[object],pro_old,l_num,fqjz_time,rgjz_time,fajz_time)   values   ( ' "&cpnum& " ', ' "&protype& " ', ' "&lotterytype& " ', ' "&protitle& " ', ' "&proexplain& " ', ' "&pronum& " ', ' "&allcost& " ', ' "&share& " ', ' "&sharecost& " ', ' "&prouser& " ', ' "&sharetake& " ', "&schedule& ", ' "&prostate& " ', ' "&proupload& " ', "&take& ", ' "&takeshare& " ', ' "&object& " ', ' "&proold& " ', ' "&lnum& " ', ' "&fqjz& " ', ' "&rgjz& " ', ' "&fajz& " ') "

end   if
conn.execute(sql)

运行时显示;

Microsoft   JET   Database   Engine   '80040e07 '  

标准表达式中数据类型不匹配。  

\wwwroot\ccp\hmpt\ssq\ds\add_hmt.asp,   line   97

本来是MS-SQL数据库,运行正常,转化成ACCESS后出现这个问题,知道这个问题被提过,但自己解决不了,希望高手帮助解决.



------解决方案--------------------
。。。。。。。。。
你自己找下数据库的哪些字段不匹配啊。。。。。。人懒了，呵
------解决方案--------------------
用response.write sql把语句输出一下,然后对比一下数据库字段类型,看是不是有不一致的.