The following code crashes an instance of VFP 6 SP3 every time.

lcQuery = "SELECT Finder.Source FROM Finder, Orders WHERE Finder.FinderNo = Orders.FinderNo GROUP BY Finder.Source"

lnResult = SQLEXEC(lnConnect,lcQuery,"Sample")

Finder table contains roughly 1,000,000 records.
Orders table contains roughly 60,000 records.
All tables are indexed.
When the tables are smaller the SELECT statement works correctly and retrieves expected results.

I am wondering if there are stored procedures I can execute?
What about the SQLSTRINGCONNECT command ?
Is there something in that command that I can change to allow this kind of query to not crash the system...

lcConnect = "DBQ=" + "\\opserver2\data1\opdb\backend\usmts.mdb" + ";" + ;
"DEFAULTDIR=" + "\\opserver2\data1\opdb\backend\" + ";" + ;
"Driver={Microsoft Access Driver (*.mdb)};DriverId=281;" + ;
"FIL=MS Access;MaxBufferSize=2048;PageTimeout=5;"

I tried changing MaxBufferSize to a significantly larger number and the hard drive just kept going and going... until I issued {CTRL-ALT-DLT} and clicked "End Task" command button.
I tried increasing the size of the 'PageTimeout' command switch.