Access web apps throttles and limits

Each Access Services application in Office 365 and SharePoint Online creates a corresponding SQL database that is subject to resource consumption limits. These limits are per database and apply whether using the web user interface or direct ODBC connection.

Important    Microsoft no longer recommends creating and using Access web apps in SharePoint. As an alternative, consider using Microsoft PowerApps to build no-code business solutions for the web and mobile devices.

Access web app limits

Limit

Maximum value

Notes

Maximum query performance level

5 DTUs

This limit is calculated as a number of Database Transaction Units or DTUs, which is a blended measure of CPU, memory, and I/O (data and transaction log I/O).

If your query exceeds the resource consumption limits, you'll receive SQL error 10928.

Maximum Access app database storage size

1 GB

1 GB is the limit for the database storage.

If the app exceeds the size limit, you'll receive SQL error 40544.

How to avoid being throttled

If queries are being throttled, there may be some ways that you can reduce the amount of resources consumed without reducing the amount of data that your Access web app is accessing. Here are some general tips to reduce resource consumption:

Expand your skills
Explore training
Get new features first
Join Office Insiders

Was this information helpful?

Thank you for your feedback!

Thank you for your feedback! It sounds like it might be helpful to connect you to one of our Office support agents.

×