Sign in
 
HomeOnline20132010Other VersionsRelated ProductsLibraryForumsGallery
TechCenter >
> 
> 
Access Services - The query has too many output columns.

Answered Access Services - The query has too many output columns.

  • Tuesday, October 05, 2010 12:05 PM
     
     
    Sign In to Vote
    0

    Trying to port a database from Access (2000 or older! via an intermediate upgrade to 2010) to use Access Services on Sharepoint 2010.  The main data entry table contains 41 columns of data and I'm getting this error when trying to load it as a web form: "The query has too many output columns. The maximum number of output columns is 40."

    I take it the database needs re-designing to split some of the data off into separate tables to be accessed on-demand?  Or is there a setting inside Sharepoint I can tweak to get the form to display?

     

All Replies

  • Monday, November 15, 2010 2:02 PM
     
     Answered
    Sign In to Vote
    0

    Checking internally I've found this message means you can't have 40 so the max is actually 39.

    Can the Access 2000 data be edited before it is brought into SharePoint to drop 2 columns?

    I am not aware of a way around this limitation in SharePoint itself.

    Fred Ellis - MSFT - "Please remember to click “Mark as Answer” on the post that helps you, and to click “Unmark as Answer” if a marked post does not actually answer your question. This can be beneficial to other community members reading the thread."
    • Proposed As Answer by Fred El - MSFT Wednesday, November 24, 2010 9:06 PM
    • Marked As Answer by Shetland John Thursday, February 03, 2011 2:21 PM
    •  
     
  • Thursday, February 03, 2011 2:21 PM
     
     
    Sign In to Vote
    0
    Fred, that's going to be the way forward when this project rears its ugly head again.
    Was it not supposed to do that?
     
  • Thursday, May 24, 2012 1:26 AM
     
     
    Sign In to Vote
    0
    This a real big and nasty surprise. We're expected to use this software for enterprise-level intranet development. I'm using the project management site template and just finished building a form with around 60 fields inside of it only to find out that more than 40 fields aren't supported? Acccess 2010 supports it, why can't SharePoint Access Services? They can't just serve up the form and have scrollbars with it?
     
  • Tuesday, September 04, 2012 11:00 AM
     
     Proposed Answer
    Sign In to Vote
    0

    Hi,

    The actuall Column  Value Limit is Not 40(its by default setting), but its between 1 to 255, you can extend the Limit with in this range(i.e upto 255 columns), by going to Acess Service Application in the Central Admin Site of SharePoint Farm.

    So do this:- Go to Central Admin -->Application Management--> Manage Service Applications -->Acess Services --> Increase "Maximum Columns Per query", which is set to 40 by default to the value suitable for your requirement.

    Hope this helps.. 

    Ankur Madaan MCTS|MCP SharePoint Application Developer 2010

    • Proposed As Answer by Ankur Madaan Tuesday, September 04, 2012 11:00 AM
    •  
     
  • Friday, November 16, 2012 11:16 AM
     
     
    Sign In to Vote
    0
    HI I am having the same isue as have a table with 60 columns I need to use.  But I am using sharepoint online with Office 365.  I dont see the options that you have listed above.  Does that mean it isnt possible on Office 365?  Any help appreciated thanks
     
  • Sunday, November 25, 2012 7:16 PM
     
     
    Sign In to Vote
    0
    Just to c,ose this off I spoke to Office 365 support and there is a current restriction of a max of 40 fields and it is not changable.  Apparently it is for performance....Another ridiculous restriction to try and work around....