Included the query:

SELECT     e_orderheader.OrderNumber, edw_orderheader.[Order number]

FROM         SESLSESGW014.E_Business.dbo.OrderHeader e_orderheader LEFT OUTER JOIN

                      dbo.[Order Header] edw_orderheader ON e_orderheader.OrderNumber = edw_orderheader.[Order number] COLLATE Latin1_General_CI_AS

WHERE     (edw_orderheader.[Order number] IS NULL)

Strange thing. When I update the...

Users working from within Access have only read-permissions; the delete-statement is performed on the sql-server in a DTS-Package.

I've done some extra test and came out with the following:

1. Display the...