Thanks Bilbo
There is no error in SQL, tables and stored procedures work fine. Problem starts in ADP form, I remove all Access default connection for DAO, and changed them to ADODB recordset etc in codes.
The main form is bound to a huge table 'tblSOF' with more than 250,000 records. There...