CA does not have any buil-in limits on # of records in a table. You can try ODBC trace to see what it's going on.
>
>What I cannot understand is this:
>
>Why does it work like a charm with only a few thousand records. Then, when it increased at the current level, it stopped working. Even with calling CursorFill() with NoData = .T. The only reason I can deduce is the fact that it has reached a critical record count.
>
>But, it works or can be accessed using SPT() or MySQL Query Browser.
>
>Geeezzz.... am getting desperate...
>