Datasheet

Number
Description
Error Numbers and Descriptions for Microsoft Access 2007
2315
The input string is too long.@@@1@@@1
2316
This table or query can't be opened because it has no visible fields.@This can result if the table
or query has only system fields, and the Show System Objects option is off.@To turn on the
Show System Objects option, click Options on the Tools menu, click the View tab, and select
the System Objects check box.@1@@@1
2317
The database '|' can't be repaired or isn't a Microsoft Office Access database file.@@@1@@@1
2319
Application-defined or object-defined error
2320
Microsoft Office Access can't display the field for which you entered Where in the Total
row.@Clear the Show check box for that field. If you want this field to appear in the query's
results, add it to the design grid twice. For the field that will appear in the query's results,
don't specify Where in the Total row, and make sure the Show check box is
checked.@@1@@@1
2321
You can't set criteria before you add a field or expression to the Field row.@Either add a field
from the field list to the column and enter an expression, or delete the criteria.@@1@@@1
2322
You can't sort on the asterisk (*).@Because the asterisk represents all fields in the underlying
table or query, you can't sort on it.@Add the asterisk to the query design grid, along with the
specific fields you want to sort on. Clear the Show check box for the sorting fields, and then
specify a sort order.@1@@@1
2323
You can't specify criteria for the asterisk (*).@Because the asterisk represents all the fields in
the underlying table or query, you can't specify criteria for it.@Add the asterisk to the query
design grid, along with the field(s) you want to set criteria for, and then enter criteria for the
specific fields. In the query design grid, clear the Show check box for the criteria field(s),
before you run the query.@1@@@1
2324
You can't calculate totals on the asterisk (*).@Because the asterisk represents all the fields in
the table, you can't calculate totals on it.@Remove the asterisk from the query design grid.
Add the fields you want to use to the design grid, and then select the total you want to
calculate for specific fields.@1@2@11202@1
2325
The field name you entered exceeds the 64-character limit of the LinkMasterFields
property.@When you use the Relationships command (on the Database Tools tab, click
Relationships) to define a relationship between the tables underlying a form and subform,
Microsoft Office Access links the form and subform automatically and sets the LinkChildFields
and LinkMasterFields properties.@@1@1@3990@1
2326
You can't specify Group By, Expression, or Where in the Total row for this column.@Specify an
aggregate function, such as Sum or Count, for the field or expression you designate as the
Value in the crosstab query.For more information on aggregate functions, click
Help.@@2@1@9980@1
2327
You must enter Group By in the Total row for a field that has Column Heading in the Crosstab
row.@The values derived from the field or expression that you designate as the Column
Heading are used to group data in the crosstab query.@@1@1@9980@1
2328
You can't run an update query on the asterisk (*).@Because the asterisk represents all the
fields in the table, you can't update it.@Remove the asterisk from the query design grid. Add
the fields you want to update to the design grid.@1@1@10001@1
2329
To create a crosstab query, you must specify one or more Row Heading(s) options, one
Column Heading option, and one Value option.@@@1@1@9980@1
2330
Microsoft Office Access can't represent the join expression | in Design view.@* One or more
fields may have been deleted or renamed.* The name of one or more fields or tables
specified in the join expression may be misspelled.* The join may use an operator that isn't
supported in Design view, such as > or <.@@1@@@1
2331
You must enter Group By in the Total row for at least one of the Row Heading options you
enter in the Crosstab row.@@@1@1@9980@1
Copyright (c) 2008 FMS, Inc.
fmsinc.com
Page 16 of 110