Microsoft Office访问在sql Query中停止工作错误 [英] Microsoft Office access has stop working error in sql Query

问题描述

我试图合并3个表，它正常工作，直到添加第三个表的地址栏。如果我添加地址列并保存或单击数据表视图突然访问表停止工作并重新启动。



这是我的代码我作为参数工作，但如果我给出正确的列将其命名为显示错误。帮我完成我的任务。

 SELECT RPT_Invoice_Less.InvoiceNumber，RPT_Invoice_Less.Terms，
 RPT_Invoice_Less.Invoicedate，RPT_Invoice_Less。我们的报价，
 RPT_Invoice_Less.SalesPerson，RPT_Customer.CustomerName，
 RPT_Customer.CustomerId，RPT_Customer.ContactPerson，
 RPT_Customer.BillingAddress，RPT_Customer.DeliveryAddress，
 RPT_Invoice_Less.OrderNumber，RPT_Invoice_Less.ShippingBy， 
 RPT_Invoice_Less.ShipReferenceNo，RPT_Invoice_Less.Notes，
 RPT_Invoice_Less.Price，RPT_Invoice_Less.Discount，RPT_Invoice_Less.Shipping，
 RPT_Invoice_Less.Tax，RPT_Invoice_Less.GrandTotal，RPT_OrionSystem.CompanyName，
 RPT_OrionSystem。 CompanyId，RPT_OrionSystem.RegistrationNumber，
 RPT_OrionSystem.Address1，RPT_OrionSystem.MobileNumber，
 RPT_OrionSystem.FaxNumber，RPT_OrionSystem.CompanyEmail，
 RPT_OrionSystem.CompanyWebsite，RPT_OrionSystem.VatTinNumber 
 
 FROM （RPT_Invoice_Less 
 
 INNER JOIN RPT_ Customer ON RPT_Invoice_Less.CustomerId = RPT_Customer.CustomerId）
 INNER JOIN RPT_OrionSystem ON RPT_Invoice_Less.CompanyId = RPT_OrionSystem.CompanyId; 

In如果我给出正确的列名<11 p $ p> RPT_OrionSystem.Address< pre> MS Access停止工作。

解决方案

您好，感谢所有，最后我使用此代码解决了这个问题

  SELECT  RPT_Invoice_Less.InvoiceNumber，RPT_Invoice_Less.Terms，RPT_Invoice_Less.Invoicedate，RPT_Invoice_Less.OurQuote，RPT_Invoice_Less.SalesPerson， RPT_Customer.CustomerName，RPT_Customer.CustomerId，RPT_Customer.ContactPerson，RPT_Customer_Address.BillingAddress，RPT_Customer_Address.DeliveryAddress，RPT_Invoice_Less.OrderNumber，RPT_Invoice_Less.ShippingBy，RPT_Invoice_Less.ShipReferenceNo，RPT_Invoice_Less.Notes，RPT_Invoice_Less.Price，RPT_Invoice_Less.Discount，RPT_Invoice_Less.Shipping，RPT_Invoice_Less。 Tax，RPT_Invoice_Less.GrandTotal，RPT_Company.CompanyName，RPT_Company.CompanyId，RPT_Company.RegistrationNumber，RPT_Company_Address.Address，RPT_Company.MobileNumber，RPT_Company.FaxNumber，RPT_Company.CompanyEmail，RPT_Company.CompanyWebsite，RPT_Company.VatTinNumber 
 
  FROM （（（RPT_Invoice_Less 
  INNER   JOIN  RPT_Customer 
  ON  RPT_Invoice_Less.CustomerId = RPT_Customer.CustomerId）
 
  INNER   JOIN  RPT_Company 
  ON  RPT_Invoice_Less.CompanyId = RPT_Company.CompanyId）
 
  INNER   JOIN  RPT_Company_Address 
  ON  RPT_Invoice_Less.CompanyId = RPT_Company_Address.AddressId）
 
  INNER   JOIN  RPT_Customer_Address 
  ON  RPT_Invoice_Less.CustomerId = RPT_Customer_Address.CustomerId; 

Hi, I tried to merge 3 tables it working fine till adding address column of third table. If i add address column and save or click Data Sheet view suddenly Access table stop working and restarts.

This is my code i working as parameter but if i give correct column name it showing error. Help me to complete my task.

SELECT RPT_Invoice_Less.InvoiceNumber, RPT_Invoice_Less.Terms, 
RPT_Invoice_Less.Invoicedate, RPT_Invoice_Less.OurQuote, 
RPT_Invoice_Less.SalesPerson, RPT_Customer.CustomerName, 
RPT_Customer.CustomerId, RPT_Customer.ContactPerson, 
RPT_Customer.BillingAddress, RPT_Customer.DeliveryAddress, 
RPT_Invoice_Less.OrderNumber, RPT_Invoice_Less.ShippingBy,
RPT_Invoice_Less.ShipReferenceNo, RPT_Invoice_Less.Notes, 
RPT_Invoice_Less.Price, RPT_Invoice_Less.Discount, RPT_Invoice_Less.Shipping, 
RPT_Invoice_Less.Tax, RPT_Invoice_Less.GrandTotal, RPT_OrionSystem.CompanyName, 
RPT_OrionSystem.CompanyId, RPT_OrionSystem.RegistrationNumber, 
RPT_OrionSystem.Address1, RPT_OrionSystem.MobileNumber, 
RPT_OrionSystem.FaxNumber, RPT_OrionSystem.CompanyEmail, 
RPT_OrionSystem.CompanyWebsite, RPT_OrionSystem.VatTinNumber

FROM (RPT_Invoice_Less 

INNER JOIN RPT_Customer ON RPT_Invoice_Less.CustomerId=RPT_Customer.CustomerId) 
INNER JOIN RPT_OrionSystem ON RPT_Invoice_Less.CompanyId=RPT_OrionSystem.CompanyId;

In the 11th line

RPT_OrionSystem.Address1

is parameter if I give correct column name

RPT_OrionSystem.Address<pre> MS Access stop working.

解决方案

Hi Thanks to all, Finally I solved this using this code

SELECT RPT_Invoice_Less.InvoiceNumber, RPT_Invoice_Less.Terms, RPT_Invoice_Less.Invoicedate, RPT_Invoice_Less.OurQuote, RPT_Invoice_Less.SalesPerson, RPT_Customer.CustomerName, RPT_Customer.CustomerId, RPT_Customer.ContactPerson, RPT_Customer_Address.BillingAddress, RPT_Customer_Address.DeliveryAddress, RPT_Invoice_Less.OrderNumber, RPT_Invoice_Less.ShippingBy, RPT_Invoice_Less.ShipReferenceNo, RPT_Invoice_Less.Notes, RPT_Invoice_Less.Price, RPT_Invoice_Less.Discount, RPT_Invoice_Less.Shipping, RPT_Invoice_Less.Tax, RPT_Invoice_Less.GrandTotal, RPT_Company.CompanyName, RPT_Company.CompanyId, RPT_Company.RegistrationNumber, RPT_Company_Address.Address, RPT_Company.MobileNumber, RPT_Company.FaxNumber, RPT_Company.CompanyEmail, RPT_Company.CompanyWebsite, RPT_Company.VatTinNumber

FROM (((RPT_Invoice_Less 
INNER JOIN RPT_Customer 
ON RPT_Invoice_Less.CustomerId = RPT_Customer.CustomerId) 

INNER JOIN RPT_Company 
ON RPT_Invoice_Less.CompanyId = RPT_Company.CompanyId) 

INNER JOIN RPT_Company_Address 
ON RPT_Invoice_Less.CompanyId = RPT_Company_Address.AddressId) 

INNER JOIN RPT_Customer_Address 
ON RPT_Invoice_Less.CustomerId = RPT_Customer_Address.CustomerId;

这篇关于Microsoft Office访问在sql Query中停止工作错误的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！