| Error Code | Error Description | Supported Versions |
| 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@209980@1 Access 2007+ uses different description: ‘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’ |
Access 2003+ |
| 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@210001@1 Access 2007+ uses different description: ‘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’ |
Access 2003+ |
| 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@209980@1 Access 2007+ uses different description: ‘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’ |
Access 2003+ |
| 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 Access 2007+ uses different description: ‘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’ Access 2010+ uses different description: ‘Microsoft Access can’t represent the join expression |1 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’ |
Access 2003+ |
| 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@209980@1 Access 2007+ uses different description: ‘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’ |
Access 2003+ |
| 2332 | Microsoft Office Access can’t match the fields you added using the asterisk (*) in the append query.@Because the asterisk represents all the fields in the underlying table or query, you can’t append an asterisk to one field or expression, and you can’t append a single field or expression to an asterisk.@Append an asterisk to an asterisk (for example, a table to a table), or append specific fields.@1@209999@1 Access 2007+ uses different description: ‘Microsoft Office Access can’t match the fields you added using the asterisk (*) in the append query.@Because the asterisk represents all the fields in the underlying table or query, you can’t append an asterisk to one field or expression, and you can’t append a single field or expression to an asterisk.@Append an asterisk to an asterisk (for example, a table to a table), or append specific fields.@1@1@9999@1’ Access 2010+ uses different description: ‘Microsoft Access can’t match the fields you added using the asterisk (*) in the append query.@Because the asterisk represents all the fields in the underlying table or query, you can’t append an asterisk to one field or expression, and you can’t append a single field or expression to an asterisk.@Append an asterisk to an asterisk (for example, a table to a table), or append specific fields.@1@1@9999@1’ |
Access 2003+ |
| 2333 | You must enter the name of the table you are creating or appending records to.@You tried to define a make-table or append query without specifying a destination table.@@1@@1 Access 2007+ uses different description: ‘You must enter the name of the table you are creating or appending records to.@You tried to define a make-table or append query without specifying a destination table.@@1@@@1’ |
Access 2003+ |
| 2334 | Microsoft Office Access can’t print ‘|’ because it is an action query.@Because action queries don’t produce a recordset, you can’t print a Datasheet view of them. Note that an exclamation point (!) joined to a query icon in the Database window marks an action query.@To print a Datasheet view of the records that will be selected by the query, display the query in Design view, click the Datasheet button, and then click the Print button.@1@@1 Access 2007+ uses different description: ‘Microsoft Office Access can’t print ‘|’ because it is an action query.@Because action queries don’t produce a recordset, you can’t print a Datasheet view of them. Note that an exclamation point (!) joined to a query icon in the Navigation Pane marks an action query.@To print a Datasheet view of the records that will be selected by the query, display the query in Design view, click the Datasheet button, and then click the Print button.@1@@@1′ Access 2010+ uses different description: ‘Microsoft Access can’t print ‘|1′ because it is an action query.@Because action queries don’t produce a recordset, you can’t print a Datasheet view of them. Note that an exclamation point (!) joined to a query icon in the Navigation Pane marks an action query.@To print a Datasheet view of the records that will be selected by the query, display the query in Design view, click the Datasheet button, and then click the Print button.@1@@@1’ |
Access 2003+ |
| 2335 | You must use the same number of fields when you set the LinkChildFields and LinkMasterFields properties.@You entered a different number of fields for one property than you did for the other. If you use the Relationships command (Tools menu) to define a relationship between the tables underlying the form and subform, Microsoft Office Access will link the form and subform automatically and then set the LinkChildFields and LinkMasterFields properties.@@1@209086@1 Access 2007+ uses different description: ‘You must specify the same number of fields when you set the LinkChildFields and LinkMasterFields properties.@You entered a different number of fields for one property than you did for the other. If you use the Relationships command (on the Database Tools tab, click Relationships) to define a relationship between the tables underlying the form and subform, Microsoft Office Access will link the form and subform automatically and then set the LinkChildFields and LinkMasterFields properties.@@1@1@9086@1’ Access 2010+ uses different description: ‘You must specify the same number of fields when you set the LinkChildFields and LinkMasterFields properties.@You entered a different number of fields for one property than you did for the other. If you use the Relationships command (on the Database Tools tab, click Relationships) to define a relationship between the tables underlying the form and subform, Microsoft Access will link the form and subform automatically and then set the LinkChildFields and LinkMasterFields properties.@@1@1@9086@1’ |
Access 2003+ |
| 2337 | You can’t specify criteria on the same field for which you entered Value in the Crosstab row.@You tried to display a crosstab query after entering Value in the Crosstab row and criteria in the Criteria row.@If you want this field to supply the cross-tabulated values in the crosstab query, delete the entry in the Criteria row. If you want this to be a criteria field, leave the Crosstab row blank.@1@209980@1 Access 2007+ uses different description: ‘You can’t specify criteria on the same field for which you entered Value in the Crosstab row.@You tried to display a crosstab query after entering Value in the Crosstab row and criteria in the Criteria row.@If you want this field to supply the cross-tabulated values in the crosstab query, delete the entry in the Criteria row. If you want this to be a criteria field, leave the Crosstab row blank.@1@1@9980@1’ |
Access 2003+ |
| 2338 | Microsoft Office Access truncated the expression you entered.@The expression ‘|’ exceeds the 1,024-character limit for the query design grid.@@1@@1 Access 2007+ uses different description: ‘Microsoft Office Access truncated the expression you entered.@The expression ‘|’ exceeds the 1,024-character limit for the query design grid.@@1@@@1′ Access 2010+ uses different description: ‘Microsoft Access truncated the expression you entered.@The expression ‘|1′ exceeds the 1,024-character limit for the query design grid.@@1@@@1’ |
Access 2003+ |
| 2339 | Microsoft Office Access can’t create a temporary link.@You reached the limit for the number of links in your database. Microsoft Office Access needs to create a temporary link in order to import your ODBC table.@Remove all unneeded links or tables.@1@@1 Access 2007+ uses different description: ‘Microsoft Office Access can’t create a temporary link.@You reached the limit for the number of links in your database. Microsoft Office Access needs to create a temporary link in order to import your ODBC table.@Remove all unneeded links or tables.@1@@@1’ Access 2010+ uses different description: ‘Microsoft Access can’t create a temporary link.@You reached the limit for the number of links in your database. Microsoft Access needs to create a temporary link in order to import your ODBC table.@Remove all unneeded links or tables.@1@@@1’ |
Access 2003+ |
| 2340 | The expression you entered exceeds the 1,024-character limit for the query design grid.@@@1@@1 Access 2007+ uses different description: ‘The expression you entered exceeds the 1,024-character limit for the query design grid.@@@1@@@1’ |
Access 2003+ |
| 2342 | A RunSQL action requires an argument consisting of an SQL statement.@For example, an action query that appends records starts with INSERT INTO. A data-definition query that creates a table starts with CREATE TABLE.@@1@603698@1 Access 2007+ uses different description: ‘A RunSQL action requires an argument consisting of an SQL statement.@For example, an action query that appends records starts with INSERT INTO. A data-definition query that creates a table starts with CREATE TABLE.@@1@1@3698@1’ |
Access 2003+ |
| 2343 | The value you entered exceeds the Alias property’s 64-character limit.@@@1@606146@1 Access 2007+ uses different description: ‘The value you entered exceeds the Alias property’s 64-character limit.@@@1@1@6146@1’ |
Access 2003+ |
| 2344 | For the TopValues property in the query property sheet, you must enter an integer greater than zero.@@@1@@1 Access 2007 uses different description: ‘For the TopValues property in the query property sheet, you must enter an integer greater than zero.@@@1@@@1’ Access 2010 uses different description: ‘For the TopValues property in the query property sheet, you must enter an integer greater than zero.@@@1@@@1’ Access 2013 uses different description: ‘The value specified for top number of rows must be an integer value greater than zero.@@@1@@@1’ Access 2016 uses different description: ‘The value specified for top number of rows must be an integer value greater than zero.@@@1@@@1’ |
Access 2003+ |
| 2345 | For the TopValues property in the query property sheet, you must enter a percentage from 1 through 100.@@@1@@1 Access 2007 uses different description: ‘For the TopValues property in the query property sheet, you must enter a percentage from 1 through 100.@@@1@@@1’ Access 2010 uses different description: ‘For the TopValues property in the query property sheet, you must enter a percentage from 1 through 100.@@@1@@@1’ Access 2013 uses different description: ‘The value specified for top percentage of rows must be a number between 1 and 100.@@@1@@@1’ Access 2016 uses different description: ‘The value specified for top percentage of rows must be a number between 1 and 100.@@@1@@@1’ |
Access 2003+ |
| 2346 | For the TopValues property in the query property sheet, you must enter a number greater than zero.@@@1@@1 Access 2007 uses different description: ‘For the TopValues property in the query property sheet, you must enter a number greater than zero.@@@1@@@1’ Access 2010 uses different description: ‘For the TopValues property in the query property sheet, you must enter a number greater than zero.@@@1@@@1’ Access 2013 uses different description: ‘The value specified for top number of rows must be a number greater than zero.@@@1@@@1’ Access 2016 uses different description: ‘The value specified for top number of rows must be a number greater than zero.@@@1@@@1’ |
Access 2003+ |
| 2347 | Microsoft Office Access can’t find the file name you entered for the DestinationDB property in an action query’s property sheet.@You may have misspelled the database file name, or the file may have been deleted or renamed.@@1@606183@1 Access 2007+ uses different description: ‘Microsoft Office Access can’t find the file name you entered for the DestinationDB property in an action query’s property sheet.@You may have misspelled the database file name, or the file may have been deleted or renamed.@@1@1@6183@1’ Access 2010+ uses different description: ‘Microsoft Access can’t find the file name you entered for the DestinationDB property in an action query’s property sheet.@You may have misspelled the database file name, or the file may have been deleted or renamed.@@1@1@6183@1’ |
Access 2003+ |
| 2348 | You can’t leave the Alias property blank.@@@1@606146@1 Access 2007+ uses different description: ‘You can’t leave the Alias property blank.@@@1@1@6146@1’ |
Access 2003+ |