Web compatibility check: Query errors
This article lists Query errors that you may encounter when you run the Compatibility Checker, and provides information that can help you resolve the errors.
For general information about Compatibility Checker errors, see the article Web compatibility check General errors.
ACCWeb102012
Error text The Query is incompatible with the Web.
What it means You must check for Web compatibility issues in the query.
What to do Recreate the query by using the query designer. For more information about how to use the query designer to create a web query, see Introduction to queries.
ACCWeb102014
Error text The SQL is incompatible with the Web.
What it means There can be many reasons why you would receive this error. You may be doing one of the following:
-
Referencing web incompatible objects.
-
Referencing web incompatible expressions.
For more information about how to create expressions, see Create an expression.
What to do Consider using the web query designer to create queries that are web compatible. For more information on designing queries for the Web, see Introduction to queries.
ACCWeb103013
Error text Access was unable to convert the query for use on the Web because the query results contain multiple fields that have the same name.
What it means Multiple fields have the same name.
What to do Check for duplicate field names and change the duplicates to distinct field names.
ACCWeb103079
Error text Type mismatch in expression.
What it means The types on either side of the join are incompatible or the field types compared are incompatible types. For example, text to number cannot be compared or joined.
What to do Ensure that the side of the joins are compatible. For example, join text type to text type and number type to number type. If you are not performing a join, check if you are comparing incompatible field types.
ACCWeb103900
Error text Access was unable to convert the query for use on the Web.
What it means Access was unable to publish the query because it uses an unsupported query type, unsupported expressions, unsupported criteria, or other features that are not supported on the Web.
What to do Use the Access query designer to redesign the query.
ACCWeb103901
Error text The definition of the query is invalid, so that the query object cannot be created.
What it means The server was unable to parse the query because of an unexpected error in the query definition.
What to do Use Access designers to redesign the query.
ACCWeb103902
Error text Access was unable to convert the query for use on the Web because it uses an unsupported query type, unsupported expressions, unsupported criteria, or other features that are not supported on the Web.
What it means The query contains expressions that are incompatible with the Web. This error can occur either because of a server restriction or when an expression cannot move to the server.
What to do Remove the expressions that are not web compatible. For more information on expressions are valid on queries see Create an expression.
ACCWeb103903
Error text The definition of the query is invalid, so that the query object cannot be created.
What it means One of the attribute values is incompatible with the Web.
What to do Ensure that the following conditions are set correctly:
-
The name attribute does not have any of the following:
| Equal sign at the beginning | = |
| Period | . |
| Exclamation mark | ! |
| Square brackets | [] |
| Blank leading space | |
| Non-printable characters | For example: <Enter> or <TAB> |
| Any of the following symbols | / \ : * ? " < > | # { } % ~ & |
-
The name attribute is between one and 64 characters long.
-
Caption attribute: Any string, up to 1024 characters.
ACCWeb103904
Error text Access was unable to convert the query for use on the Web because it contains a sub-query.
What it means The query contains a subquery. Subqueries are not supported on the server.
What to do Modify your query so that it does not have a sub query.
ACCWeb103905
Error text Access was unable to convert the query for use on the Web because it relies on a different query that is not Web compatible.
What it means The query either contains a nested query as a input that cannot be represented on the server or it contains an input source that cannot be found.
What to do
-
Ensure that the nested query is valid.
-
Use Access query designers to create a valid nested query.
-
Ensure that the query input source table or query exists in the database.
ACCWeb103906
Error text The definition of the query is invalid, so that the query object cannot be created.
What it means The source table or query of the selected or order by columns cannot be found.
What to do Ensure that the column input source table or query exists in your Access database.
ACCWeb103907
Error text Access was unable to convert the query for use on the Web because it does not include any fields in its results.
What it means No columns are selected in the query.
What to do Select or specify at least one output column in the query.
ACCWeb103908
Error text Access was unable to convert the query for use on the Web because it displays too many fields in its results.
What this means The query source has too many columns.
What to do This may be difficult to resolve and you might have to examine the source tables. A table can have no more than:
-
JET_ccolFixedMost fixed columns.
-
JET_ccolVarMost variable-length columns.
-
JET_ccolTaggedMost tagged columns.
ACCWeb103916
Error text Access was unable to convert the query for use on the Web because it relies on an ORDER BY clause that is not supported on the Web..
What this means One or more of the following conditions exists:
-
Name of an order by element is not valid.
-
Name of source table is not valid.
-
Sort order is set to an option other than ascending or descending.
-
The expression is not valid.
What to do Ensure that the following conditions are set correctly:
-
The name attribute does not contain any of the following:
| Equal sign at the beginning | = |
| Period | . |
| Exclamation mark | ! |
| Square brackets | [] |
| Blank leading space | |
| Non-printable characters | For example: <Enter> or <TAB> |
| Any of the following symbols | / \ : * ? " < > | # { } % ~ & |
-
The name attribute is between one and 64 characters long.
-
The expression is a valid expression.
ACCWeb103918
Error text Access was unable to convert the query for use on the Web because it specifies a JOIN type that is not supported on the Web.
What it means The server does not support queries that have multiple joins between two tables (multi-field joins).
What to do Ensure that the joins use only one field per table.
ACCWeb103926
Error test Access was unable to convert the query for use on the Web because it does not specify which table to SELECT FROM.
What it means The query has no input tables (missing the FROM clause).
What to do Ensure that your query has an input column specified.
ACCWeb103927
Error text Access was unable to convert the query for use on the Web because the query results contain multiple fields that have the same name.
What it means You specified the same name for multiple fields.
What to do Check for duplicate field names and change the duplicates to distinct field names.
ACCWeb103928
Error text Access was unable to convert the query for use on the Web because some of its parameters could not be converted for use on the Web.
What it means The parameter name or type is not valid.
What to do Ensure that the parameter name and type are valid.
-
The name attribute has does not contain:
| Equal sign at the beginning | = |
| Period | . |
| Exclamation mark | ! |
| Square brackets | [] |
| Blank leading space | |
| Non-printable characters | For example: <Enter> or <TAB> |
| Any of the following symbols | / \ : * ? " < > | # { } % ~ & |
-
The name attribute is between one and 64 characters long.
The following types are valid:
| Text (up to 255 characters) |
| Numbers |
| Boolean |
| DateTime |
| Currency |
ACCWeb103930
Error text Access was unable to convert the query for use on the Web because some of its parameters are displayed as result fields or used in ORDER BY statements.
What it means The query has a parameter that is either projected as a scalar or used in an order by statement.
This can occur if a parameter is used either as a projected column (Example: select param1 from Table1) or as order by (Example: select * from table 1 and order by field1= param).
What to do Avoid using parameters that are projected column or order by column.
ACCWeb103938
Error text Access was unable to convert the query for use on the Web.
What it means There are two fields that have same name and Access is unable to create valid aliases for them.
What to do Check for duplicate field names and change the duplicates to distinct field names.
ACCWeb103939
Error text Access was unable to convert the query for use on the Web.
What it means The query has an alias that is greater than 64 characters.
What to do Ensure the alias used in the query is less than or equal to 64 characters.
ACCWeb103940
Error text Access was unable to convert the query for use on the Web because it specifies a JOIN type that is not supported on the Web.
What it means The server does not support queries that have multiple joins on the same two tables (multi-field joins).
What to do Ensure that the joins you are using only one field per table.
ACCWeb103942
Error text Access was unable to convert the query for use on the Web because it contains a cyclical join.
What it means The joins between the tables in your query are causing a circular join between the tables which is preventing Access from converting the query for use on the Web.
What to do Remove joins between tables so that the cyclical joins are removed.
No comments:
Post a Comment