Datasheet

ErrorCode ErrorString

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.

2424 The expression you entered has a field, control, or property name that

Microsoft Access can’t find.

2425 The expression you entered has a function name that Microsoft Access

can’t find.

2426 The function you entered can’t be used in this expression.

• You may have used a DoEvents, LBound, UBound, Spc, or Tab func-

tion in an expression.

• You may have used an aggregate function, such as Count, in a design

grid or in a calculated control or field.

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

trol.

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.

2429 The In operator you entered requires parentheses.

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

2431 The expression you entered contains invalid syntax. You may have

entered a comma without a preceding value or identifier.

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”.

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.

2434 The expression you entered contains invalid syntax. You may have

entered an operand without an operator.

2435 The expression you entered has too many closing parentheses.

Access 2002 and Jet 4 Errors

PPENDIX E

ACCESS 2002

AND

JET

RRORS