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?
View Complete Post