Important Access Services 2010 and Access Services 2013 are being removed from the next release of SharePoint. We recommend you do not create new web apps, and migrate your existing apps to an alternative platform, such as Microsoft Power Apps.
This article lists Relationship and Lookup 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.
Error text Column data type is incompatible with web lookups.
What it means The data type of the indicated lookup field is not supported on the Web.
What to do Make sure the lookup field is one of the following supported data types:
Single line of text
Calculated field that returns a single line of text
Error text The lookup bound column must be the primary key to be compatible with the Web.
What it means The bound column of the indicated lookup field is not the primary key of the target lookup table.
What to do Re-create the lookup field by using the lookup wizard. Specify the primary key column of the target lookup table as the bound column.
Error text Lookup row sources must be complete SQL statements with one table and table fields specified to be compatible with the Web.
What it means One or both of the following conditions is true:
The query for the indicated lookup uses more than one table or query as a data source.
The columns used in the query are not explicitly selected.
What to do Re-create the lookup, making sure that:
The lookup uses one web compatible table as its data source.
Tip: Any table that is not compatible with the web should have created a row in the Web Compatibilty Issues table when you ran the Compatibilty Checker.
The lookup query specifies each field explicitly (i.e., do not use SELECT *).
Error text Multi-column lookups with a Row Source Type of Value List must be bound to "Col1" to be compatible with the Web.
What it means The indicated multi-column lookup is not bound to Col1.
What to do Use the lookup wizard to re-create the lookup field. Make sure that you bind to Col1 of the value lookup.
Error text Value list lookups must contain at least one row of data to be compatible with the Web.
What it means The value list for the indicated lookup is empty, and so is not compatible with the Web.
What to do Supply at least one row of data in the value list for the lookup field.
Error text Value Lists with empty values are incompatible with the Web.
What it means This happens when there are missing column values in a single row of a value lookup. This is incompatible with the web.
What to do Make sure that the fields in the single row of the value list are specified. Either use Design view to set this Row Source or use the Lookup Wizard. (On the Fields tab, in the Properties group, click Modify Lookup.)
Error text The table for the lookup row source cannot be found.
What it means The table specified as the the row source of the indicated lookup does not exist.
What to do Specify a valid row source for the lookup. You can use the Lookup Wizard to re-create the lookup.
Error text SQL statements containing calculated result columns for lookup row sources are incompatible with the Web.
What it means The indicated lookup field has an expression in its row source, which is therefore not compatible with the web. For example, the following is not a valid row source for a web lookup field: SELECT ([First Name] & " " & [Last Name]) FROM Contacts;
What to do Consider creating a calculated column in the underlying table and then re-creating the lookup field.
Error text Lookup row sources can only reference one table to be compatible with the Web.
What it means The row source for the indicated lookup field contains multiple tables.
What to do Use the lookup wizard to recreate the lookup so that it only references one table. This may require you to change your data model.
Error text Enable Referential Integrity must be False if Allow Multiple Values is True for a lookup.
What it means The indicated lookup field allows multiple values but the relationship it models enforces referential integrity, which requires a single value for the lookup.
What to do Remove referential integrity on the relationship, or recreate the lookup field without allowing multiple values.
Error text Limit to List must be True if Allow Multiple Values is True.
What it means The lookup property Limit to List is set to False for the indicated field but Allow Multiple Values is set to True.
What to do Set the Limit to List property for the lookup field to True; or, set Allow Multiple Values to False.
Error text Lookups require an associated Relationship to be compatible with the Web.
What it means The indicated lookup field does not have an associated relationship.
What to do Create a relationship between the lookup field and the field that it refers to.
Error text The lookup row source SQL statement must include the source table primary key field and that field must be the bound column.
What it means The query for the indicated lookup field does not contain the primary key of the source table, and is therefore not comatible with the web.
What to do Use the Lookup Wizard to re-create the lookup field.
Error text SQL statement for lookup row source is incompatible with the Web.
What it means The SQL statement for the row source of the indicated lookup field is either ill-formed or is incompatible with the Web for a variety of reasons, such as it includes an unsupported SQL operator.
What to do Use the Lookup Wizard to re-create the lookup field.
Error text Tables with lookup columns must have a primary key and the primary key must be a long data type.
What it means Either the lookup target table foreign key or the source table primary key is not a long integer, or both.
What to do Make sure that both source and target fields of the lookup are long integers. You may want to create new fields for this purpose.
Error text Lookup type must be '|0' or '|1' to be compatible with the Web.
What it means The indicated lookup field references a field list as its row source.
What to do Use the Lookup Wizard to recreate the lookup field. This may require you to change your data model.
Error text Relationships that are not associated with a valid lookup field are incompatible with the Web.
What it means The relationship is not supported by a lookup field, and is therefore not compatible with a web database.
What to do Create a lookup field between the related tables. Use the Lookup Wizard to create the lookup.
Error text Calculated Column result data type for lookups must be Text to be compatible with the Web.
What it means The first display column of the indicated lookup field is a calculated column with a data type other than Text.
What to do Change the data type of the calculated field to Text, or re-create the lookup field and choose a different first display column.