>>- If you're working with ActiveXs you may need to experiment with _VFP.AutoYield
>>
>>- It might help to put DOEVENTS calls in looping code
>
>I've been trying these.
>
>>
>>- Never used it, but SYS( 2336 ) is related to MTDLLs
>
>Thanks, I'll investigate.
>
>>
>>Can you tell what the long processes are, such as SELECT - SQL that's taking a long time to run? It's possible to work around some of those issues.
>
>Well I don't think it's the SQL, but, I'm pretty sure its related to the number crunching after that. What possible work arounds are you hinting at?

For SELECT - SQL, you can add a dummy column which is the result of a UDF, which calls DoEvents e.g.

SELECT ;
  SomeColumns ;
  , MyUDF( ) AS DummyColumn ;
  ...

FUNCTION MyUDF

DOEVENTS

RETURN .T.

Can you show us sample code of your number crunching? It is very complex/takes a long time to run?