question

paulc avatar image
paulc asked

all of a sudden im getting a could not be bound error message, it worked fine always up to last week but today it failed.

this is my code. the error message is "the multi-part identifier "scheme.porchdm.transactn"could not be bound (#4104).

I designed the query in design mode, not actually by writing the SQL, so please keep answers simple.

SELECT [Outstanding Orders].supplier, [Outstanding Orders].name,
[Outstanding Orders].order_no, [Outstanding Orders].line, [Outstanding
Orders].wh, [Outstanding Orders].product, [Outstanding Orders].analysis_a AS
[group], [Outstanding Orders].date_required, [Outstanding Orders].qty_ordered,
[Outstanding Orders].qty_received, [Outstanding Orders].balance, [Outstanding Orders].packaging,
[Outstanding Orders].[num ctns], [Outstanding Orders].tran_code3, [Outstanding
Orders].memo1, [Outstanding Orders].memo2, [Q Numbers (qty not
zero)].transactn, [Q Numbers (qty not zero)].vessel, [Q Numbers (qty not
zero)].comments, [Q Numbers (qty not zero)].lot_number, [Q Numbers (qty not
zero)].port_embark, [Q Numbers (qty not zero)].port_arrive, [Q Numbers (qty not
zero)].leave_date, [Q Numbers (qty not zero)].arrival_date,
IIf([receipt_date]<[arrival_date],"-",[receipt_date]) AS [WH date],
[Q Numbers (qty not zero)].quantity_logged, [Q Numbers (qty not
zero)].post_status
FROM [Outstanding Orders] LEFT JOIN [Q Numbers (qty not zero)] ON ([Outstanding Orders].line = [Q Numbers (qty not zero)].line_number) AND ([Outstanding Orders].order_no = [Q Numbers (qty not zero)].order_no)
WHERE ((([Q Numbers (qty not zero)].transactn) Is Null Or ([Q Numbers (qty not zero)].transactn) Like "K*" Or ([Q Numbers (qty not zero)].transactn) Like "N*" Or ([Q Numbers (qty not zero)].transactn) Like "P*" Or ([Q Numbers (qty not zero)].transactn) Like "M*" Or ([Q Numbers (qty not zero)].transactn) Like "A*" Or ([Q Numbers (qty not zero)].transactn) Like "B*" Or ([Q Numbers (qty not zero)].transactn) Like "C*"))
ORDER BY [Outstanding Orders].date_required;
sqlerror-message
4 comments
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Oleg avatar image Oleg commented ·

@paulc The query in your question does not even contain "scheme.porchdm.transactn" so there should be no way for you to get the error 4104 you are getting unless you are running some other query, not the one in your question. The query as written is not friendly because it is generated by the tool, but the syntax is valid (looks like it is a valid Access query).

0 Likes 0 ·
KenJ avatar image KenJ Oleg commented ·

reasonable chance that [Q Numbers (qty not zero)] is a view (or another access query?) that references "scheme.porchdm.transactn". The underlying table or view may have been changed.

0 Likes 0 ·
paulc avatar image paulc commented ·

yes, this query is referencing 2 other queries, one if which does container the field in question/error. These are Access queries and were done in design view, nothing has changed in this or source queries/tables.

0 Likes 0 ·
Oleg avatar image Oleg paulc commented ·

@paulc What happens when you just run the select just from the query which has the field in question/error? If nothing has been changed then that query should produce results. If not then it suggests that something did change in the definition of that query.

0 Likes 0 ·

0 Answers

·

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.