Using Quickbooks Premier 2004, I get the following error:

2006-10-20 01:21:14 QODBC Ver:  6.00.00.176 *********************************************************************************************************************
IsAService: False
SQL Statement: SELECT Top 1 * FROM Item WHERE FullName LIKE '%Unattended%' ORDER BY FullName
Invalid Table Name in Open Table. (Item)

2006-10-20 01:21:15 QODBC Ver:  6.00.00.176 *********************************************************************************************************************
IsAService: False
Invalid Table Name in Open Table. (Item)

It works fine with both the Canadian and USA Quickbooks.  I can query the Item table with VBDemo.  With the Australian version, it crashes my application.

Sorry, my subscription of my Australian copy of QuickBooks 2004 has long expired, however I had no problems at all using:

SELECT Top 1 * FROM Item WHERE FullName LIKE '%Bathroom%' ORDER BY FullName

with my QuickBooks 2006/07 Premier edition.