Sudden issue opening large sql table in access
Posted on 2014-09-08
A serious issue suddenly occurred to my Access ADP as follows.
When opening a large table (1.5 Million records), I get an error when trying to scroll down to the bottom of the table,
error message states "Data Provider or other service returned an E_Fail Status"
what's strange is that I can still open that with an previous version of the app.
Compact/repair did not help, also did change connection to test and back to production, nothing changed.
FYI- this is an Access 2000 ADP linked to SQL Express 2005.