mdb占内存过大
每次点按钮执行DoCmd.RunSQL "select iif(isnull(a.CAI),b.CAI,a.CAI) as CAI,Zone,[Sub zone],Country,MOIS,PAYSVENT,CM,TM,REGMRQ,MARQUE_CODE,CATCOM,CLIENT,TER,VENTES,[Nation Code],[Market Code],[Product Code],Month0,Month1,Month2,Month3,Month4,Month5,Month6,Month7,Month8,Month9,Month10,Month11,Month12,Month13,Month14,Month15,Month16,Month17,Month18,MARQUE,SCULPTURE,DIM,FAMLIGP,[MACRO 6],[MACRO 7],[MICRO 11],DIASEAT,CHARGE1,CHARGE2,SYMBVIT,MARKET,FACTORY,LC,[Disc RT] into [query_temp2] from (select * from [query_temp1] a left join [Commercial Catalogue] b on a.CAI=b.CAI union select * from [query_temp1] a right join [Commercial Catalogue] b on a.CAI=b.CAI)"
这句话生成一张表以后,我发现我的mdb就会变大几十M,只有关闭mdb后才会回到以前的大小,有没有释放内存的命令来控制mdb大小呢?