سلام
از اينكه به من جواب ميدين متشكرم.
من كد شما رو با يه كم دستكاري نوشتم ولي بازم ارور ميده . اگه اينجوري بنويسم ميگه not a valid password
SELECT nakh.name, Sum(nakh.Vazn) AS [Sum Of Vazn], noe_nakh.name AS lname
into newtbl in 'c:\data2.mdb' [;PWD=1021]
FROM noe_nakh INNER JOIN nakh ON noe_nakh.nakh_cod=nakh.name
GROUP BY nakh.name, noe_nakh.name;
و اگه به صورت زير بنويسم ميگه could not find installable ISAM
SELECT nakh.name, Sum(nakh.Vazn) AS [Sum Of Vazn], noe_nakh.name AS lname
into newtbl in 'c:\data2.mdb' 'PWD=1021;'
FROM noe_nakh INNER JOIN nakh ON noe_nakh.nakh_cod=nakh.name
GROUP BY nakh.name, noe_nakh.name;