在遗留系统中使用vb.net查询MSACCESS97EFAIL

Question

当我从.net运行以下查询时，它出现了一个efail错误

​

但是当我运行sql脚本抛出访问时，它是成功的，这是一个遗留系统，顺便说一下，我支持它，在线上说它是保留字，但我在这个查询中看不到任何大小和前缀？

SELECT 
    Orders.OrderNumber, 
    Orders.OrderLine, 
    Orders.Orderdate, 
    Orders.Deldate, 
    Orders.CutOffDate, 
    detail.Location, 
    Location.Description,   
    TagBarCode.TagBcode, 
    detail.PLU, 
    Style.Description, 
    StockType.Description,
    VatRate.Vcode, 
    VatRate.Vatname, 
    VatRate.VatRate, 
    Orders.OnOrder, 
    Sum(Orders.Cost*Orders.Onorder) AS LineNetCost, 
    Orders.Cost, 
    Sum(orders.cost*(1+(VatRate.VatRate/100))) as GrossCost
FROM (
 (
  (
    (
      (Style INNER JOIN detail ON Style.uniqueref = detail.UniqueRef)
      INNER JOIN Orders ON (Orders.PLU = detail.RootPlu) 
                       AND (Style.uniqueref = Orders.UniqueRef) 
                       AND (detail.Size = Orders.Size) 
                       AND (detail.Location = Orders.Location)
    ) 
    INNER JOIN StockType ON detail.Stocktype = StockType.Stocktype
   ) 
   INNER JOIN Location ON detail.Location = Location.Location
  ) 
  INNER JOIN TagBarCode ON (detail.RootPlu = TagBarCode.Plu) AND (detail.Size = TagBarCode.Size)
 ) 
 INNER JOIN VatRate ON detail.VCode = VatRate.Vcode
GROUP BY 
    Orders.OrderNumber, 
    Orders.OrderLine, 
    Orders.Orderdate, 
    Orders.Deldate, 
    Orders.CutOffDate, 
    detail.Location, 
    Location.Description, 
    TagBarCode.TagBcode, 
    detail.PLU, 
    Style.Description, 
    Orders.OnOrder, 
    StockType.Description, 
    VatRate.Vcode, 
    VatRate.Vatname, 
    VatRate.VatRate, 
    orders.cost;

Answer 1

显然你需要像下面这样描述，因为Location.Description是一个保留字