在ACCESS数据库如何获得刚INSERT INTO的记录自动生成的ID字段值?
例如:
sql1="Insert into consumer(username,male,address,zip,tel,email,url,fax,memo) values ("_
&"'"&username&"',"_
&""&male&","_
&"'"&address&"',"_
&"'"&zip&"',"_
&"'"&tel&"',"_
&"'"&email&"',"_
&"'"&url&"',"_
&"'"&fax&"',"_
&"'"&memo&"')"
sql2="Insert into carduser(consumerid,cardid,cardnumb,password,buydate,payoff,employeeid,operatorip) values ("_
&"'"&consumerid&"',"_
&"'"&cardid&"',"_
&"'"&cardnumb&"',"_
&"'"&password&"',"_
&"'"&buydate&"',"_
&""&payoff&","_
&"'"&employeeid&"',"_
&"'"&operatorip&"')"
其中SQL2里consumerid就是SQL1添加的那条记录自动生成的ID,如何获得?