Action Failed
Sorry, the server isn't responding
The action will continue to run in background.
Error Number -8000

I also get a consistent error saying the macro timed out and to contact the app developer.

The Error Number on the time-out is 2950

This macro deletes a table with 37K record and the append new data from another table (about 37K records).  Worker very reliably for a while - only took 10 seconds or so to run.  There have been no design changes to the macro.  The fact that the Access Web Apps have this ability is the only reason I built this health claims reporting app.  Generally, the delete query is finished and the append query is in progress.  Now the resources don't appear to be there.

Any thoughts.  I really want this to work.

I can run these queries on a desktop using pass through queries.

Thanks for any help or thoughts.

You know - it would be great if web apps could connect externally to a .CSV file on OneDrive (w perhaps 400K records in it).

• Edited by Econographics Thursday, June 18, 2015 10:22 AM

Hi,

Please change "Run Macro" to "Run Data Macro" in your access app.

Here is a similar thread for you to take a look at:

https://social.msdn.microsoft.com/Forums/office/en-US/4669fa10-ba7a-4a2e-8039-66cdae43831c/access-2013-web-app-data-macro-times-out-with-action-failed-sorry-the-server-isnt-responding?forum=sharepointdevelopment

Best Regards