Troubleshooting - Error 3120 - Object X specified in the request cannot be found.

Problem Description:

I could link all tables to an MS Access DB from QuickBooks Database.

But I got the following error when I tried to open the ItemAssembliesCanBuild table.

ERROR [00000] [QODBC] Error: 3120 - Object "X" specified in the request cannot be found.

Solution:

ItemAssembliesCanBuild Query does require ItemInventoryAssemblyRef(ListID or FullName) and TxnDate in the WHERE Clause to perform the query in QuickBooks SDK.

You will get this error when you execute a query directly without specifying ItemInventoryAssemblyRef(ListID or FullName) and TxnDate.

So it would be best to execute the query with ItemInventoryAssemblyRef(ListID or FullName) and TxnDate through a custom query.

For Example:
SELECT * FROM ItemAssembliesCanBuild where ItemInventoryAssemblyRefFullName='Inventory Door Kit' and TxnDate={d'2017-12-15'}

It would be best if you wrote the query in MS Access from MS Access >> create tab >> Query Design.

Select Pass-Through >> Write query >> Execute the query using the Run button.

Select DSN & execute the query.

Query executed successfully & result available.