Thursday, October 19, 2017

Web compatibility check: Schema errors

Web compatibility check: Schema errors

This article lists Schema 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.

Use the Lookup Wizard to create or modify a lookup field

ACCWeb105003

ACCWeb105012

ACCWeb105018

ACCWeb107000

ACCWeb107001

ACCWeb107002

ACCWeb107003

ACCWeb107004

ACCWeb107005

ACCWeb107006

ACCWeb107007

ACCWeb107008

ACCWeb107009

ACCWeb107010

ACCWeb107011

ACCWeb107012

ACCWeb107013

ACCWeb107014

ACCWeb107015

ACCWeb107016

ACCWeb107017

ACCWeb107018

ACCWeb107019

ACCWeb107020

ACCWeb107021

ACCWeb107022

ACCWeb107023

ACCWeb107024

Use the Lookup Wizard to create or modify a lookup field

Many Schema errors are caused by problems with lookup fields. These procedures explain how to launch the Lookup Wizard in Datasheet view to fix these problems by creating or modifying a lookup field.

Create a lookup field in Datasheet view

  1. Open the table to which you want to add a lookup field, and select the last column, labeled Click to Add.

  2. Click the arrow next to Click to Add, and then click Lookup & Relationship.

  3. Follow the steps of the Lookup Wizard to create the lookup field that you need.

Modify a lookup field in Datasheet view

  1. Open the table and select the lookup field that you want to modify.

  2. Do one of the following:

    • On the Fields tab, in the Properties group, click Modify Lookups.

    • Right-click the lookup field, and then click Modify Lookups.

  3. Follow the steps of the Lookup Wizard to fix your specific problem.

ACCWeb105003

Error text    Column data type for value list lookups must be 'Text' to be compatible with the web.

What it means    The indicated lookup uses a list that is not supported in a web database. The value list must be bound to a text column on the server.

What to do    Open the table in Design view, and change the data type of the lookup field to Text. If Design view is not available, delete the lookup field, and then use the Lookup Wizard to re-create it.

Top of Page

ACCWeb105012

Error text    Lookup row sources with clause clauses are incompatible with the Web.

What it means    The indicated lookup field uses a query that contains a WHERE clause, which is not supported on the Web.

What to do    Open the table in Design view and remove the WHERE clause from the Row Source property of the relevant lookup field. If Design view is not available, delete the lookup field, and then use the Lookup Wizard to re-create it.

Top of Page

ACCWeb105018

Error text    A primary key which is a lookup is incompatible with the web.

What it means    The indicated table has a primary key which is a lookup field that refers to another table, which is not supported on the Web.

What to do    Open the table in Design view, and change the Control Type property for the lookup field to Textbox (on the Lookup tab). Then, open the Relationships Window and delete any relationships in which the lookup field is on the many- side of the relationship (the arrow points away from the lookup field).

If Design view and the Relationships window are not available, do the following:

  1. Create a new blank database (not a web database).

  2. Import the tables that you need from the original database into the new database.

  3. Make the required changes in the new database.

  4. In the original database, delete the tables, and then import them from the new database.

Top of Page

ACCWeb107000

Error text    Field data type is incompatible with the Web.

What it means    The indicated field has a data type that is not supported on the web, such as OLE Object.

What to do    Recreate the field as one of the supported data types:

  • Text

  • Number

  • Currency

  • Yes/No

  • Date/Time

  • Calculated field

  • Attachment

  • Hyperlink

  • Memo

  • Lookup

Top of Page

ACCWeb107001

Error text    Composite indexes are incompatible with the Web.

What it means    The indicated table has a composite primary key (a key consisting of more than one field). You can only use an Autonumber field as the primary key for a Web table. You cannot use composite indexes on the Web.

What to do    If the composite index was for a primary key, create an Autonumber primary key for the indicated table. Then, create a record validation rule to make sure that the data in the original fields is unique.

Top of Page

ACCWeb107002

Error text    Table with more than one Attachment field is incompatible with the Web.

What it means    The indicated table contains more than one attachment field, which causes failure during a publish operation, and is therefore incompatible with the Web.

What to do    Consider storing all the attachments for each record in a single attachment field. If you need more than one attachment field per record, for each additional attachment field create a new table that contains only the attachment field and an ID field, and then link the new table and the original table by using the Lookup Wizard.

Top of Page

ACCWeb107003

Error text    Calculated Field expression has an input field of a type incompatible with the Web, such as AutoNumber, Memo or Binary.

What it means    The indicated calculated field uses a calculation that takes as input a field that is not supported on the Web.

What to do    Adjust the calculation so that all input fields have one of the following supported data types:

  • Text

  • Number

  • Currency

  • Yes/No

  • Date/Time

  • Calculated field

Top of Page

ACCWeb107004

Error text    Calculated Column result data type is incompatible with the Web.

What it means    The result of the calculation for the indicated field is a data type that is not supported on the web.

What to do    Re-create the calculated field so that the resulting data type is one of the following supported data types:

  • Text

  • Number

  • Currency

  • Yes/No

  • Date/Time

Top of Page

ACCWeb107005

Error text    Table with more than 220 fields is incompatible with the Web.

What it means    The indicated table contains more than 220 fields. You cannot publish a table with more than 220 fields to the Web.

What to do    Create a new table to contain the additional fields. Then, use the Lookup Wizard to create a new field that links the new table to the existing table.

Top of Page

ACCWeb107006

Error text    Table name is a reserved name and incompatible with the Web.

What it means    The indicated table name is reserved for use by SharePoint and is not supported on the Web.

What to do    Avoid using any of the following reserved table names:

  • UserInfo

  • Lists

  • Docs

  • WebParts

  • ComMd

  • Webs

  • Workflow

  • WFTemp

  • Solutions

  • Report Definitions

  • MSysASO

Top of Page

ACCWeb107007

Error text    Unpublished tables with lookups to published tables are incompatible with the web.

What it means    The indicated table is not yet published, and contains a lookup field that points to a published table, which will prevent publishing.

What to do    Publish the unpublished table without adding a lookup. You can Sync the web database to achieve this. After the new table is published, create the desired lookup to the other published table.

Top of Page

ACCWeb107008

Error text    Custom formats are incompatible with the Web

What it means    The indicated field has a custom currency format, which is not supported on the Web.

What to do    Use a standard currency format for the field. Set the field format to Currency or Euro by using the Formatting dropdown.

Top of Page

ACCWeb107009

Error text    Only one of the Allow Zero Length property and Required property should be set to 'true' to be compatible with the Web.

What it means    The indicated field has both its Allow Zero Length and Required properties set to True.

What to do    Make sure that at most one of the indicated properties is set to True. You can use Design view to change these properties.

Top of Page

ACCWeb107010

Error text    Property value should be set to 'no' to be compatible with the Web.

What it means    The Append Only property of the indicated hyperlink field is set to Yes, which is not supported on the Web.

What to do    Change the Append Only property to No.

Top of Page

ACCWeb107011

Error text    The default value should be empty to be compatible with the Web.

What it means    The indicated lookup field has a default value in a lookup query or in a list that allows multiple values, which is not supported on the Web.

What to do    Make sure that there is:

  • No default value set for the lookup query; or

  • No default value set for the lookup value list that allows multiple values

Top of Page

ACCWeb107012

Error text    The default value should be empty to be compatible with the Web.

What it means    The indicated hyperlink field has a default value, which is not supported on the Web.

What to do    Remove the default value for the hyperlink field.

Top of Page

ACCWeb107013

Error text    Property value is not compatible with the Web.

What it means    The indicated Number field has its Format property set to something besides General Number, Percent or Standard. Only these formats are supported on the Web.

What to do    Change the field's Format to General Number, Percent or Standard.

Top of Page

ACCWeb107014

Error text    A Table should have a Primary Key and it should be a number with field size 'long' to be compatible with the Web.

What it means    The indicated table has one of the following problems:

  • The table does not have a primary key.

  • The data type of the primary key is not Number.

  • The primary key Field Size is not Long.

What to do    Change the existing primary key in Design view so that it has the correct data type and Field Size; or, create a new primary key for the table, using the AutoNumber data type. If Design view is not available, create a new table, and add to it the columns from the original table; then drop the original table.

Top of Page

ACCWeb107015

Error text    Property value should be set to 'false' to be compatible with the Web.

What it means    The Unique property of the indicated Memo field is set to True, which is not supported on the Web.

What to do    Change the value of Unique to False.

Top of Page

ACCWeb107016

Error text    Property value should be set to 'false' to be compatible with the Web.

What it means    The Unique property of the indicated Yes/No field is set to True.

What to do    Change the value of Unique to False.

Top of Page

ACCWeb107017

Error text    Property value should be set to 'false' to be compatible with the Web.

What it means    The Unique property of the indicated hyperlink field is set to True, which is not supported on the Web.

What to do    Change the value of Unique to False.

Top of Page

ACCWeb107018

Error text    The bound column should be set to the Primary Key of the table and it should be the first column to be compatible with the Web.

What it means    The indicated lookup field has one of the following problems:

  • The bound column is set to a field other than the primary key of the source table.

  • The bound column is not the first column of the lookup.

What to do    Use the Lookup Wizard to modify the lookup field.

Top of Page

ACCWeb107019

Error text    Property value should be set to 'yes' to be compatible with the Web.

What it means    The Limit To List property of the indicated lookup field is set to No, but the lookup field is not a single-valued value list, and the property setting is therefore not compatible with the Web.

What to do    Use the Lookup Wizard to modify the lookup field. Make sure you select the Limit to List checkbox when the wizard displays it.

Top of Page

ACCWeb107020

Error text    Property value should to be empty to be compatible with the Web.

What it means    The Link Child Fields property of the indicated field is not empty, and therefore not compatible with the Web.

What to do    Open the table in Design view and clear the Link Child Fields property. Then, set the Subdatasheet Name property to [Auto] or [None]. If Design view is not available, in Datasheet view, on the Home tab, in the Records group, click More, point to Subdatasheet, and then click Remove.

Top of Page

ACCWeb107021

Error text    Property value should to be empty to be compatible with the Web.

What it means    The Link Master Fields property of the indicated field is not empty, and therefore not compatibile with the Web.

What to do    Open the table in Design view and clear the Link Master Fields property. Then, set the Subdatasheet Name property to [Auto] or [None]. If Design view is not available, in Datasheet view, on the Home tab, in the Records group, click More, point to Subdatasheet, and then click Remove.

Top of Page

ACCWeb107022

Error text    Property value should to be empty or set to 'auto' to be compatible with the Web.

What it means    The Subdatasheet Name property of the indicated field is not set to [Auto] nor [None], and is therefore not compatible with the Web.

What to do    Open the table in Design view and set the Subdatasheet Name property to [Auto] or [None]. If Design view is not available, in Datasheet view, on the Home tab, in the Records group, click More, point to Subdatasheet, and then click Remove.

Top of Page

ACCWeb107023

Error text    Property value should to be specified to be compatible with the Web.

What it means    The Column Width property of the indicated lookup field is empty, and therefore not compatible with the Web.

What to do    Open the table in Design view, and specify a value for Column Width (on the Lookup properties tab). Or, select the column in Datasheet view, and on the Fields tab, in the Properties group, click Modify Lookups. Follow the steps in the Lookup Wizard.

Top of Page

ACCWeb107024

Error text    Autonumber is not supported for any other field but primary key.

What it means    The indicated field uses an AutoNumber data type but is not the primary key of the table, and is therefore not compatible with the Web.

What to do    Change the data type of the field to Number. As a workaround, you can use data macros to achieve a similar functionality. Change the field with this property to the primary key in Design view, or change the data type to Number.

Top of Page

No comments:

Post a Comment