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
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
-
Open the table to which you want to add a lookup field, and select the last column, labeled Click to Add.
-
Click the arrow next to Click to Add, and then click Lookup & Relationship.
-
Follow the steps of the Lookup Wizard to create the lookup field that you need.
Modify a lookup field in Datasheet view
-
Open the table and select the lookup field that you want to modify.
-
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.
-
-
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.
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.
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:
-
Create a new blank database (not a web database).
-
Import the tables that you need from the original database into the new database.
-
Make the required changes in the new database.
-
In the original database, delete the tables, and then import them from the new database.
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
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.
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.
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
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
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.
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
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.
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.
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.
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.
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
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
No comments:
Post a Comment