In MS Access we have used ODBC to connect to the Sage 100 ver 2019 data files.  We get an ODBC error when accessing the AP_InvoiceHistoryDetail table (a very large file).  In MS Access we see the linked file.  I open it and go to the last record.  It works successfully.  When I close the file then reopen it in Access and try to go the last record again I get the error:

[ProvideX][ODBC Driver][FILEIO] Unable to allocate memory to perform requested operation (#14) in MS Access

This happens every time I try to reopen the file and go to the last record.  However, if I exit MS Access and reopen the database and try again I can go to the last record successfully with no error on the first attempt.  All subsequent attempts fail again.

Why does the connection work the first time and fails every time thereafter?  How can I get the connection to work every time?  We have several queries in the database that use this table.  These queries will error out with the same message.  I need the connection to work every time.  I have not been able to find anything regarding the ODBC driver, it's settings or anything else that will get the connection to survive the first attempt.

As a last resort, I made a query to copy the entire file into a local table in Access.  This works every time with no error (I did both a make table query and an append query - both work).  However this process takes a while and I would rather use the ODBC connection for my queries to expedite reporting in the database.

Any suggestions on what is causing the ODBC error and how to get the ODBC connection to work every time?

TIA for suggestions