Sign up for Office 365
Learn more about Office 365
Trying to upload tables as Sharepoint lists. Virtually all of the tables are interrelated so I cannot upload them just one at a time. The total database is about 175 mb. and some of the tables hold as many as 166,000 items. I believe that what is happening is that I am exceeding the 20-minute time out and thus the message "System Resource Exceeded". Is there any way to work around this?
This is Tim with Microsoft Office 365 SharePoint Support.
You problem seems to be two-fold. First, if you are trying to publish the database using Access services on your SharePoint site, the 166,000 items is surpassing the list view threshold. Second, since that file is large, you can be running into a time out issue. You may want to either think about just uploading the database and not use access services, or break apart the database into smaller chunks. I will continue to monitor this thread if you have any additional questions.
Microsoft Office 365 SharePoint Support
This is Jason Burnside from Microsoft Office365 SharePoint Support.
Tim’s response laid out a couple options that you can try to resolve your issue. After trying Tim’s options, please let us know if your issue is resolved.
I will continue to monitor this thread if you have any additional questions.
Office 365 SharePoint Support