Error Code Error Description Supported Versions
2396 Microsoft Office Access can’t create an index or primary key.@One or more field names are missing.@Enter or select at least one field in the Field Name column for each index you name.@1@@1
Access 2007+ uses different description: ‘Microsoft Office Access can’t create an index or primary key.@One or more field names are missing.@Enter or select at least one field in the Field Name column for each index you name.@1@@@1’
Access 2010+ uses different description: ‘Microsoft Access can’t create an index or primary key.@One or more field names are missing.@Enter or select at least one field in the Field Name column for each index you name.@1@@@1’
Access 2003+
2397 You already have an index named ‘|.’@@@1@@1
Access 2007+ uses different description: ‘You already have an index named ‘|.’@@@1@@@1’
Access 2003+
2398 The primary key has been changed.@This table is the primary table in one or more relationships. Changes to the primary key won’t be saved.@@1@@1
Access 2007+ uses different description: ‘The primary key has been changed.@This table is the primary table in one or more relationships. Changes to the primary key won’t be saved.@@1@@@1’
Access 2003+
2399 The setting for the FieldSize property must be from 1 through 8000.@@@1@@1
Access 2007+ uses different description: ‘The setting for the FieldSize property must be from 1 through 8000.@@@1@@@1’
Access 2003+
2400 The row you inserted in the grid exceeds the limit of 255 rows (fields) for a table or 1,000 rows (actions) for a macro.@@@1@@1
Access 2007+ uses different description: ‘The row you inserted in the grid exceeds the limit of 255 rows (fields) for a table or 1,000 rows (actions) for a macro.@@@1@@@1’
Access 2003+
2401 You can’t delete the ‘|1’ column at this time. @The ‘|1’ column is part of the primary key for the ‘|2’ table. It is used to identify and store the rows in your table in the database.@You cannot delete a primary key while using Datasheet view. To delete the primary key, open the table in Design view and remove the primary key field.@1@@@1 Access 2007+
2420 The expression you entered has an invalid number.@@@2@611732@1
Access 2007+ uses different description: ‘The expression you entered has an invalid number.@@@2@1@11732@1’
Access 2003+
2421 The expression you entered has an invalid date value.@@@2@611729@1
Access 2007+ uses different description: ‘The expression you entered has an invalid date value.@@@2@1@11729@1’
Access 2003+
2422 The expression you entered has an invalid string.@A string can be up to 2048 characters long, including opening and closing quotation marks.@@1@@1
Access 2007+ uses different description: ‘The expression you entered has an invalid string.@A string can be up to 2048 characters long, including opening and closing quotation marks.@@1@@@1’
Access 2003+
2423 The expression you entered has an invalid . (dot) or ! operator or invalid parentheses.@You may have entered an invalid identifier or typed parentheses following the Null constant.@@2@611736@1
Access 2007+ uses different description: ‘The expression you entered has an invalid . (dot) or ! operator or invalid parentheses.@You may have entered an invalid identifier or typed parentheses following the Null constant.@@2@1@11736@1’
Access 2003+
2424 The expression you entered has a field, control, or property name that Microsoft Office Access can’t find.@@@1@@1
Access 2007+ uses different description: ‘The expression you entered has a field, control, or property name that Microsoft Office Access can’t find.@@@1@@@1’
Access 2010+ uses different description: ‘The expression you entered has a field, control, or property name that Microsoft Access can’t find.@@@1@@@1’
Access 2003+
2425 The expression you entered has a function name that Microsoft Office Access can’t find.@@@1@@1
Access 2007+ uses different description: ‘The expression you entered has a function name that Microsoft Office Access can’t find.@@@1@@@1’
Access 2010+ uses different description: ‘The expression you entered has a function name that Microsoft Access can’t find.@@@1@@@1’
Access 2003+
2426 The function you entered can’t be used in this expression.@* You may have used a DoEvents, LBound, UBound, Spc, or Tab function in an expression.
* You may have used an aggregate function, such as Count, in a design grid or in a calculated control or field.@@1@@1
Access 2007+ uses different description: ‘The function you entered can’t be used in this expression.@* You may have used a DoEvents, LBound, UBound, Spc, or Tab function in an expression.
* You may have used an aggregate function, such as Count, in a design grid or in a calculated control or field.@@1@@@1’
Access 2003+
2427 You entered an expression that has no value.@The expression may refer to an object that has no value, such as a form, a report, or a label control.@@1@@1
Access 2007+ uses different description: ‘You entered an expression that has no value.@The expression may refer to an object that has no value, such as a form, a report, or a label control.@@1@@@1’
Access 2003+
2428 You entered an invalid argument in a domain aggregate function.@* A field in the string expression may not be in the domain.
* A field specified in the criteria expression may not be in the domain.@@2@610931@1
Access 2007+ uses different description: ‘You entered an invalid argument in a domain aggregate function.@* A field in the string expression may not be in the domain.
* A field specified in the criteria expression may not be in the domain.@@2@1@10931@1’
Access 2003+
2429 The In operator you entered requires parentheses.@@@1@@1
Access 2007+ uses different description: ‘The In operator you entered requires parentheses.@@@1@@@1’
Access 2003+
2430 You did not enter the keyword And in the Between…And operator.@The correct syntax is as follows:
expression [Not] Between value1 And value2@@1@@1
Access 2007+ uses different description: ‘You did not enter the keyword And in the Between…And operator.@The correct syntax is as follows:
expression [Not] Between value1 And value2@@1@@@1’
Access 2003+
2431 The expression you entered contains invalid syntax.@You may have entered a comma without a preceding value or identifier.@@1@@1
Access 2007+ uses different description: ‘The expression you entered contains invalid syntax.@You may have entered a comma without a preceding value or identifier.@@1@@@1’
Access 2003+
2432 The expression you entered contains invalid syntax, or you need to enclose your text data in quotes.@You may have entered an invalid comma or omitted quotation marks.
For example, if the Default Value property of a text field is ”Huey, Louie, and Dewey,” it must be enclosed in quotes if you mean it as a literal text string. This avoids the confusion with the expression ”Huey Louie” And ”Dewey”.@@1@@1
Access 2007+ uses different description: ‘The expression you entered contains invalid syntax, or you need to enclose your text data in quotes.@You may have entered an invalid comma or omitted quotation marks.
For example, if the Default Value property of a text field is ”Huey, Louie, and Dewey,” it must be enclosed in quotes if you mean it as a literal text string. This avoids the confusion with the expression ”Huey Louie” And ”Dewey”.@@1@@@1’
Access 2003+
2433 The expression you entered contains invalid syntax.@You may have entered an operator, such as the + operator, in an expression without a corresponding operand.@@1@@1
Access 2007+ uses different description: ‘The expression you entered contains invalid syntax.@You may have entered an operator, such as the + operator, in an expression without a corresponding operand.@@1@@@1’
Access 2003+

Pages:Previous page Next page