rs1.open ("select * from area where areaname='"&areaname&"' order by id desc"),conn,1,1 看看你怎么写的把括号去掉rs1.open "select * from area where areaname='"&areaname&"' order by id desc",conn,1,1
rs1.open ("select * from area where areaname='"&areaname&"' order by id desc"),conn,1,1改成rs1.open "select * from [area] where areaname='"&areaname&"' order by id desc",conn,1,1