Web Query Limits

Question

In trying to work through a suggestion from Ken Sheridan in a response to an earlier question, I find that there appears to be a limit of 8 "OR" lines in a WEB query.  Since Ken doesn't use Access for Web databases, I'm sure he won't mind me posting this issue.  Is there an easy work around this limitation or do I have to break things into separate queries, which will be another challenge altogether?

Answer 1

This is very interesting, Tom, and I thank you.  This is the first time I've heard anything at all about A2013 and any differences between it and A2010.  Even A2010 is new to me, as I was quite happy with A2007 until I needed to create this Web database I'm working on.  By far the most challenging aspect has been that A2010 Web databases do not use VBA.  I will look into A2013.

I am currently using the Office365 Small Business Premium.  Just getting to the point where I could make that decision took more searching and asking than I would have believed possible.  However, like most issues, now that I have a slim grasp of what is available and practical, the decision wasn't too difficult.

With regard to the A2010 WEB query limitations and a bit of reading between the lines, I'm assuming that the 8 line limit is a hard limit.  The reason for this is that we want to be able to search on any one or more of 8 to 10 variables to drill down our data to a few choices.   It appears that an A2010 query will only handle two variables.

Answer 2

If you are using A2010 web databases, you should REALLY look at A2013: it is a new implementation so different from the previous version that upgrading isn't even possible. IOW, A2010 web is a dead end. Most of your skills writing macros will transfer, but your app will not.

A2013 web databases use SQL Server as the back-end (yet still rely on SharePoint for middle-tier functionality), so in theory you would only be limited by T-SQL.

If you already have Office 2013, the most affordable option is the “Office 365 Small Business” for $6/mo/user.  If you don’t have Office 2013 (and you will need it to edit Access 2013 web apps) you can get the “Office 365 Small Business Premium” or “Office 365 Midsize Business” for $15/mo/user.  One of the major differences between Small Business, Midsize and Enterprise is how many users it will support.