ODBC Issue Linking from MS Access to FM6

[mc14702]

I have spoke with FM Support and they can duplicate the issue but are not sure how to solve it as it is with the Filemaker Pro ODBC driver developed by Merant (no longer Merant). It has a problem accessing several 1,000 records. I receive an error along the lines: unknown error an attempt to fetch forward... I am trying to link to FM6 via the Filemaker Pro ODBC driver from Excel and MS Access 97. Please help!