Take the 2-minute tour ×
SharePoint Stack Exchange is a question and answer site for SharePoint enthusiasts. It's 100% free, no registration required.

I have created a sharepoint list in 2013 by importing an access 2013 table which has 7414 records and have set the list to sync with the table held on my local PC. I want to start over again but when I try to delete the list on my sharepoint site I get error message "the the list exceeds the 5000 limit" and I am unable to delete it. How can I overcome this? I have full owner permissions. Graham

share|improve this question
    
I believe there are plenty of solutions here for you in a previous similar question: sharepoint.stackexchange.com/questions/26542/… –  Hugh Wood Apr 23 '13 at 17:03

3 Answers 3

Owner permissions are not enough. You need to either have a Site Collection Administrator delete the list or find out when the Large List Threshold Window is for your organization and delete it then.

Alternatively, you might be able to create a view that shows less than 5000 items, then use the DataSheet view to bulk delete until the list total is below 5000. This probably won't work as you will likely hit the same error trying to create the view but it is worth a shot.

share|improve this answer

Resource Throttling "List View Threshold" property limits the maximum number of items that a database operation can involve at one time. It is 5000 by default. You can change it in:

Central Administration -> Manage Web Applications -> Select WebApp -> General Settings/Resource Throttling -> Change "List View Threshold".

share|improve this answer
    
Please don't post answers in bulk. You have posted the identical answer to sharepoint.stackexchange.com/questions/66529 and sharepoint.stackexchange.com/questions/66573. –  SPDoctor Apr 23 '13 at 19:08
    
Can't do this. The Sharepoint site I am using is hosted by Microsoft and the highest permission is Administrator or Owner, of which I am both. I can only access ADMIN options for Office 365 or Sharepoint neither of which are any help. –  sirocco Apr 23 '13 at 19:11
    
Check this link community.office365.com/en-us/forums/148/p/79787/… . Hope it will help. –  Andrew Apr 23 '13 at 19:46

link to the sharepoint list with MS-Access (2007 is good enough) and just run a query 'delete * from table' and then let it run and go for coffee ....This link through MS_Access does not appear to be limited by the view threshold (also not for displaying the contents of a list)

The actual deletion is slow (in my case just a few rows per second) and deleted rows go to recycle bin but you only need to run the query, no further interaction required.

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.