Hi all,

I am a vba programmer. I am getting an error message as odbc call failed.
I am using a linked table having upto 72 laks records.

Pl help me. its very urgent.

strsql = "Select * from [10_kardex] Where site='0801' and item_code='TJC5 00411' and bal_qty > 0 and tran_type = 'RCT-TR' and tran_date in (Select distinct tran_date from [10_kardex] Where tran_date between #30/05/2005# and #30/05/2007#...