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+ |