The columns names given are incorrect, but:

Select QuantityOnHand, TotalValue, InventoryDate, AverageCost,
QuantityOnOrder, QuantityonSalesOrder from ItemInventory

worked without a problem on Microsoft Windows Vista and QuickBooks 2007:

Try rebuilding your optimizer table by running:

sp_optimizefullsync ItemInventory

My recommended settings for using the QODBC optimizer are shown here:

See: How do I setup the QODBC Optimizer? Where are the Optimizer options?  for an explaination of all the options available to you.

The ItemInventory columns/fields affected by Null/Dirty Reads/Real Time settings are:

• QuantityOnHand
• TotalValue
• AverageCost
• QuantityOnOrder
• QuantityOnSalesOrder

When you do a: SELECT * when "For balances and stock quantities" is set as NULL, then the values are returned as NULLS. You can change the optimizer to use dirty reads, or stop using SELECT * and specify the fields instead like this:

Select QuantityOnHand, TotalValue, InventoryDate, AverageCost,
QuantityOnOrder, QuantityonSalesOrder from ItemInventory

I would hazard to guess that either the MAKE TABLE actually does a SELECT * underneath or your connection string in MS Access still stores the original optimizer settings when you first linked the QODBC tables. You will need to change the optimizer to use dirty reads, rebuild the table using:-

sp_optimizefullsync ItemInventory

and then unlink the all the tables and re-link them. Try using VB Demo to confirm QODBC is actually working correctly.

See: How do I use the VB Demo for testing?