Tell me more ×
SharePoint Stack Exchange is a question and answer site for SharePoint enthusiasts. It's 100% free, no registration required.
up vote 0 down vote favorite

When opening a large list in Access, the open is timing out at 30 seconds. The list is fairly large, smaller lists open just fine.

Any ideas on how to "open this up"?

share|improve this question

1 Answer

up vote 0 down vote

You "may" need to increase the http timeout limit in the IIS web config file for the web application where you have the site running with the list.

Said that, you "have" to also check the following options through Central Administration > Application Management > Manage Service Applications > Access Service Application

Maximum Request Duration increase this to 300
Maximum Session Memory

Set the above to a considerable large number depending on the size of your list and the number of items.

share|improve this answer
in my web.config my first httpRuntime entry is <httpRuntime maxRequestLength="51200" /> what should I change that to? – Bryan Smith May 29 '12 at 15:05
did you check the central administration related settings as well – Arko D May 29 '12 at 15:06
Yes, I already bumped those up, I'm thinking i need to tweak the httpRuntime line in the web.config – Bryan Smith May 29 '12 at 15:13
I changed the max execution on the httpRuntime and reset IIS, and it still didn't resolve the problem. – Bryan Smith May 30 '12 at 12:32
What is the size of the list in terms of item count ? – Arko D May 31 '12 at 13:56
show 1 more comment

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.