Show All

Summary of messages in Microsoft Access Project Designers

All messages for the user interface components in a Microsoft Access project, including Database Designer, Table Designer, Query Designer, Query Builder, and SQL Text Editor are listed below in alphabetical order.

Note  Additional messages are documented in the Microsoft SQL Server Books Online help information.

<0s> cannot be used in this query type.

<0s> in expression is not part of the query.

<0s> support not available in this server version.

A blank constraint expression is not allowed.

A database diagram with that name already exists in the database.

A number of rows were affected.

A pair of matching columns is required to create a relationship.

A primary key can't be created on column '<0s>' because it allows null values.

A primary key or index cannot be created on columns with a datatype of <0s>.

A primary key or index cannot have more than <0d> columns.

A primary key or unique constraint must be defined for table '<0s>' before it can participate in a relationship.

A relationship cannot contain more than '<0d>' columns.

Adding a formula to the selected column will delete all indexes and relationships it participates in.

Adding a formula to the selected column will delete all relationships it participates in as a foreign key.

ALIAS name is already being used.

ALL cannot be used with CUBE or ROLLUP.

Ambiguous outer join (+) operator.

An expression cannot be used as a parameter value.

An index can't exist on a blank column.

Another user modified this database diagram while you were working on it.

Appropriate SQL cannot be generated.

Are you sure you want to delete the selected relationship from your database?

Are you sure you want to permanently delete table '<0s>' from your database?

Are you sure you want to permanently delete the selected tables from your database?

Asterisk (*) may not be used in an indexed view.

Bad top value.

Both sides of a relationship must have the same number of columns.

Cannot assign alias to this field.

Cannot convert entry to valid date/time.

Cannot convert to proper type.

Cannot delete rows with unknown keys.

Cannot edit rows with unknown keys.

Cannot edit this cell.

Cannot filter this expression.

Cannot insert into this expression.

Cannot open encrypted <0s> <1s>.

Cannot put expression on select list.

Cannot update this expression.

Cannot use column whose data type is image or text in this context.

Cannot use long data type in this context.

Changing a column data type results in an index that is too large.

Changing the column to the selected data type will delete its indexes and all relationships it participates in.

Changing the column to the selected data type will delete its indexes.

Changing the column to the selected data type will delete relationships.

Changing this alias will result in a duplicate output column name.

Collate clause may not be used in an indexed view.

Column '<0s>' is a computed column, and cannot contribute to foreign keys.

Column '<0s>' is a computed column, and cannot participate in indexes or relationships.

Column '<0s>' is used to enforce the full-text key on table <1s> and must be <2d> bytes or less.

Column '<0s>' participates in full-text indexing on table '<1s>'. After this change, the column will no longer participate in the table's full-text index.

Column '<1s>' in table '<0s>' participates in index '<2s>'. Columns with a datatype of '<3s>' cannot participate in indexes or primary keys.

Column cannot be updated.

Column has no name and will be deleted.

Column is the full-text filter for columns that participate in full-text indexing on a table.

Columns in this expression have incompatible collations.

Comment exceeds n bytes.

Connection failure.

Data source alias is read only.

Data source base name is read only.

Data type error in expression.

Data type mismatch - no conversion possible.

Data type mismatch - use the Transact SQL CONVERT function.

Database Designer Error

Database Server Version Runtime Error.

Default Value property cannot be set on column '<0s>' because it is a computed column.

DELETE statement conflicted with COLUMN REFERENCE constraint.

Deleting the selected columns will also delete relationships.

Do you want to save changes in this database diagram?

Do you want to save changes in this table?

Do you want to suppress further error messages telling you why records can't be pasted?

Editing this default will permanently unbind the named default.

Edits not allowed. HAVING clause not allowed in an indexed view.

Enter an expression in the Column cell first.

Error after function '<0s>'

Error after predicate near '<0s>'

Error before EXISTS clause.

Error before EXISTS clause: '<0s>' not recognized.

Error before FROM clause.

Error following UNION operator.

Error in column list.

Error in column list: '<0s>' not recognized.

Error in destination table specification.

Error in FROM clause near '<0s>'

Error in GROUP BY clause near '<0s>'.

Error in GROUP BY clause.

Error in HAVING clause near '<0s>'.

Error in HAVING clause.

Error in INSERT statement.

Error in INSERT statement: '<0s>' not recognized.

Error in join expression.

Error in join expression: '<0s>' not recognized.

Error in list of function arguments: '<0s>' not recognized.

Error in list of values in IN clause.

Error in list of values in IN clause: '<0s>' not recognized.

Error in list of values.

Error in list of values: '<0s>' not recognized.

Error in ON clause near '<0s>'.

Error in optional FROM clause.

Error in ORDER BY clause near '<0s>'.

Error in ORDER BY clause.

Error in SELECT clause: alias '<0s>' not recognized.

Error in SELECT clause: alias not recognized.

Error in SELECT clause: expression near '<0s>'.

Error in set list in UPDATE clause.

Error in table name or view name in DELETE clause.

Error in table name or view name in DELETE clause: '<0s>' not recognized.

Error in table name or view name in INSERT clause.

Error in table name or view name in INSERT clause: '<0s>' not recognized.

Error in table name or view name in UPDATE clause.

Error in text following query statement: '<0s>'.

Error in values list in INSERT INTO clause.

Error in values list in INSERT INTO clause: '<0s>' not recognized.

Error in WHERE clause near '<0s>'.

Error loading table.

Error validating constraint.

Error validating the default for a column.

Error validating the formula for column.

Function argument count error.

Identity column '<0s>' in table '<1s>' must have a datatype of int, smallint, tinyint, decimal or numeric with scale of 0.

Identity seed must be a number containing <0d> digits or less.

If you save the view encrypted, you will no longer be able to alter the view definition.

Ignoring illegal use of ALL.

Ignoring ODBC syntax.

Illegal sequence use.

Illegal use of collation clause.

Illegal use of expression list.

Illegal use of outer join operator.

Incomplete column list.

Incomplete parameters list.

Incomplete parameters or column list.

Incomplete SET clause.

Incomplete VALUES list.

Index '<0s>' is used to enforce the full-text key on table '<1s>' and must be <2d> bytes or less.

Index '<0s>' is used to enforce the full-text key on table '<1s>' and must be single-column.

Index '<0s>' is used to enforce the full-text key on table '<1s>' and must be unique.

Index '<0s>' is used to enforce the full-text key on table '<1s>' and must not be null.

Index already exists.

Index must have at least one column.

Indexed View must contain a clustered index.

Internal Error.

Invalid data type.

Invalid entries must be resolved before you can exit this pane.

Invalid escape character.

Invalid fill factor; enter an integer between 0 and 100.

Invalid identifier '<0s>'.

Invalid name. You must provide a name for this object.

Invalid or missing expression near '<0s>'.

Invalid or missing expression.

Invalid prefix or suffix characters.

Invalid row index: Goto failed.

Invalid text or symbol.

Invalid view name.

IS operator can only be used with NULL or NOT NULL.

Linked Server object cannot be used as a destination with this query type.

Missing escape character in LIKE predicate.

Missing FROM clause near '<0s>'.

Missing FROM clause.

Missing FROM keyword near '<0s>'.

Missing FROM keyword.

Missing INTO keyword near '<0s>'.

Missing INTO keyword.

Missing or incomplete SELECT clause.

Missing pattern in LIKE predicate.

Missing SET keyword.

Missing subquery correlation name.

Missing subquery or the operator you entered requires parenthesis.

Missing subquery.

Must enter either TRUE or FALSE.

Need alias for this field.

NOT cannot be used in a column cell.

Object name cannot begin with #.

Object with name already exists in the database.

ODBC driver returned an invalid ODBC version and needs to be updated.

One or more selected tables are already on the database diagram.

Only one clustered index can be created on table '<0s>'.

Only one ROWGUID column is allowed per table.

OpenRowset cannot be used as a destination with this query type.

ORDER BY not supported for CREATE TABLE query.

Outer join column may not be used with an IN predicate or subquery.

Poorly formed comment.

Poorly formed Transact SQL CAST function.

Primary key or index cannot be created on a column with no name.

Primary key or index cannot be created on column '<0s>' because its data type is '<1s>'.

Property cannot be modified.

Query Designer Error.

Query Designer supports no more than 1 table for this type of query.

Query has executed successfully.

Relationship '<0s>' was modified or deleted since the database diagram was loaded.

Removing the formula from the selected column leaves it with data type that is disallowed in indexes and relationships.

Row limit value should be between <xxx> and <xxx>.

Rows pasted.

Select both primary key table and foreign key table before selecting any field for the relationship.

Setting for Length must be from <0d> to <1d>.

Setting for Precision must be from <0d> to <1d>.

Setting for Scale must be from <0d> to <1d>.

SQL statement could not be parsed.

SQL text cannot be represented in the grid pane and diagram pane.

SQL Verify failed.

Summary of messages in Access Project Designers

Syntax error in table reference.

Syntax error in table reference: '<0s>' not recognized.

Table '<0s>' already exists.

Table '<0s>' has no columns.

Table '<0s>' is marked for deletion and was not added to the diagram.

Table '<0s>' no longer exists in the database.

Table is not in the query definition.

Table name cannot include the double-quote character (").

The alias name is too long.

The Allow Nulls property can't be set on a column that is part of the primary key.

The Allow Nulls property can't be set on column '<0s>' because it is an identity column.

The collation properties of columns <0s> and <1s> do not match.

The columns in table '<0s>' do not match an existing enabled primary key or UNIQUE constraint.

The columns in table '<0s>' do not match an existing primary key or UNIQUE constraint.

The database row you are modifying no longer exists in the database.

The datatype of column '<1s>' in the '<0s>' table can't be changed because it participates in index '<2s>'.

The Default Value property can't be set on column '<0s>' because it is an identity column.

The existing relationship must have at least one pair of related columns.

The following datatype or size property of '<0s>.<1s>' doesn't match '<2s>.<3s>'.

The following error was encountered while changing the collation: <0s>.

The following schema-bound objects will be modified.

The identity increment must be a number containing <0d> digits or less.

The Identity property can't be set on column '<0s>' because it allows null values.

The Identity property can't be set on column '<0s>' because it has a default value.

The index is used to enforce the full-text key for this table. Deleting this index will disable full-text indexing for the table. Do you want to proceed?

The name is too long.

The new relationship must have at least one pair of related columns.

The NOT keyword may not be used in a column cell.

The number of selected columns exceeds the number of columns in the target table.

The primary key or UNIQUE constraint cannot be changed until its existing relationships are deleted.

The primary key or Unique constraint cannot be changed while relationships to the existing primary key or Unique constraint are enforced.

The Query Designer does not support the <0s> SQL construct.

The Query Designer does not support the critical ODBC APIs.

The Query Designer does not support the current ODBC API.

The specified OR group number is already in use.

The SQL Server does not meet minimum requirements of version 6.5 service pack 3.

The SQL syntax has been verified against the data source.

The table being loaded into memory has a user-defined data type that is not recognized.

The table must have at least one column that is not computed.

The table-valued function used as target is not an in-line function.

The total size of an index or primary key cannot exceed 256 bytes.

The value for the extended property is too long.

The value you entered is not consistent with the data type or length of the column.

There are no columns selected. Please select one or more columns and re-run the query

There are not enough columns to match the value list.

There are not enough values in the subquery select list.

There are too many values from the sub-query select list.

There is no unique table in this query.

This backend version is not supported to design database diagrams or tables.

This cell contains the text string "<NULL>" which may not be processed correctly.

This operator cannot be used with columns with data type "uniqueidentifier".

This SQL statement type cannot be used in a view.

Too many characters for field width.

Too many or too few parameters specified.

Unable to execute create script because it does not begin with CREATE or ALTER.

Unable to execute create script because it does not begin with CREATE.

Unable to execute the create script; the table name is invalid or missing.

Unable to locate data source.

Unable to parse expression.

Unable to parse query text.

Unable to parse statement.

Unable to read object text; the text is encrypted.

Unable to save; the object name is invalid or missing.

Unexpected object type.

Unknown column.

Unknown conversion specification.

Unquoted alias contains white space.

Use of GROUP BY function in WHERE clause not allowed.

Use of Transact SQL CONVERT function might be unnecessary.

Values for '<0s>' must lie within the range <1d> to <2d>.

Values for property must lie within the range x to y.

View already exists in the database.

View definition includes no output columns or no items in the FROM clause.

View has indexes. If you remove schema binding, the indexes will be dropped.

View name cannot begin with #.

Warning: It is likely that the view definition will result in a view that cannot be indexed.

Warning: It is likely that your modification will result in a view that cannot be indexed.

WITH TIES clause requires an ORDER BY clause.

You are about to delete a row or rows.

You are about to paste n rows.

You are not logged in as the database owner or as a user that is a member of the db_owner role. You will not be able to save changes to tables that you do not own.

You cannot create a view which is self-referenced.

You entered <0d> characters for '<1s>'. The maximum number of characters allowed is <2d>.

You entered x characters for a property; the maximum allowed is y.

You might not have permission to perform this operation, or the object <0s> might no longer exist in the database.

Your database diagram will be updated with the following changes to match the database before the following tables can be loaded.

Your entry cannot be converted to a valid date time value.

Your Logon does not have CREATE TABLE permission; you might not be able to make certain edits that require this permission.

Your table will be updated with the following changes to match the database.