Sunday, August 13, 2017

Web compatibility check: Relationship and Lookup errors

Web compatibility check: Relationship and Lookup errors

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.

ACCWeb105000

ACCWeb105001

ACCWeb105002

ACCWeb105003

ACCWeb105004

ACCWeb105005

ACCWeb105006

ACCWeb105007

ACCWeb105008

ACCWeb105009

ACCWeb105010

ACCWeb105011

ACCWeb105012

ACCWeb105014

ACCWeb105015

ACCWeb105016

ACCWeb105017

ACCWeb105000

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

  • Date/Time

  • Number

  • Calculated field that returns a single line of text

Top of Page

ACCWeb105001

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.

Top of Page

ACCWeb105002

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 *).

Top of Page

ACCWeb105003

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.

Top of Page

ACCWeb105004

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.

Top of Page

ACCWeb105005

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.)

Top of Page

ACCWeb105006

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.

Top of Page

ACCWeb105007

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.

Top of Page

ACCWeb105008

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.

Top of Page

ACCWeb105009

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.

Top of Page

ACCWeb105010

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.

Top of Page

ACCWeb105011

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.

Top of Page

ACCWeb105012

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.

Top of Page

ACCWeb105014

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.

Top of Page

ACCWeb105015

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.

Top of Page

ACCWeb105016

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.

Top of Page

ACCWeb105017

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.

Top of Page

No comments:

Post a Comment