bfi – canaries – 1 flight up

40 column limitation is lurking out there for sure. There’s also a 5,000 row limitation as well? Kiddy pool limitations folks.

 40 columns?

 5,000 rows?

http://social.msdn.microsoft.com/Forums/en-US/90c24c11-7846-433b-b532-4e0739c66786/access-services-and-sharepoint-list-query-limits?forum=accessdev

One more tech. reference – seems to confirm 40 row limit. Is this on premises sharepoint group trying to protect their turf (and paycheck?).

http://community.office365.com/en-us/forums/148/t/117690.aspx