SQL Serve中SQL语句执行Access中子SQL语句

exec sp_addlinkedserver
@server = 'access',   
@provider = 'Microsoft.Jet.OLEDB.4.0',   
@srvproduct = 'OLE DB Provider for Jet',  
 @datasrc = 'C:/Inetpub/wwwroot/jasmine/packinglist/20051221pk-bridal.mdb'

exec ('sp_addlinkedsrvlogin  ''access'', ''false'' ')
 exec( ' select count( a.styleid)  YCount ,a.styleid ,(select count(*)  JCount from stylecode b with (nolock)  where  b.styleid=a.styleid  and b.prodline in (select prodlineid from prodline with (nolock) where  prodkind=0) ) JCount     from  OPENQUERY(access, ''select  styleid from suppacklistcart'')  a   group by a.styleid  order  by JCount  ')
 EXEC sp_droplinkedsrvlogin 'access', NULL
exec sp_dropserver 'access'