Microsoft Access ODBC call failed

Microsoft Access ODBC call failed

So, this kind of might have been the timeout after all. Within style view I changed the qualities with the look at through Overview to be able to "Dynaset (Inconsistent Updates)" (even though Milliseconds doesn't describe within the on the internet assist just what that precisely means). I would go with Picture because there's no need in order to revise the info, however because of the fairly wide range of records, Milliseconds advises using Dynaset. Furthermore the Timeout from the view had been changed to be able to nine hundred mere seconds (15 minutes ), in the event that our SQL Host is doing several real function This might be insufficient. It will be helpful which instead of ODBC-Call hit a brick wall, MS Access would certainly state something such as "Timeout expired", yet presently there probably is a further reason why this is not possible.

Leaving the actual query: Dynaset, Dynaset (Inconsistent Updates), Overview? As a skilled P/SQL as well as T/SQL, my partner and I concept of just what MS Access will be talking about right here. The actual paperwork is fairly dodgy furthermore. My partner and I reality I only need to browse the information (it really is regarding reporting).