>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.

Also see if you have the latest ODBC driver for Access. (from the MDAC download at MS)