Thanks but if I run it the different error message occurs:

"Microsoft ODBC Visual FoxPro Driver Fox Error1", what's going on?

I have trapped for the previous error message, and the error comes when the following codes runs:

mRS10.Open "SELECT * FROM PAYP order by LPB", mCN1, adOpenKeyset, adLockOptimistic

can you help me? thanks a lot


Regards
Winan