ACC2002: Access Quits When You Sort a Table While Renaming a Column (295232)

The information in this article applies to:

This article was previously published under Q295232

Novice: Requires knowledge of the user interface on single-user computers.

This article applies only to a Microsoft Access database (.mdb).

SYMPTOMS

When you sort a table while one of its columns is being renamed, Microsoft Access may quit and you receive the following error message:

Microsoft Access has encountered a problem and needs to close. We are sorry for the inconvenience.

This behavior occurs when the table is sorted before the new name is committed.

To work around this issue, press ENTER to commit the column name change before you sort the records.

Microsoft has confirmed that this is a problem in the Microsoft products that are listed at the beginning of this article.

Create the following new table:

   Table: Table1
   ----------------------
   Field Name: Col1
   Data Type:  Text

Open Table1 in Datasheet view.
On the Format menu, click Rename Column.
Rename column "Col1" as "Col2." Do not press ENTER.
On the Records menu, point to Sort, and then click Sort Ascending. Notice that Access quits and you receive the error message described in the "Symptoms" section of this article.

Modification Type:	Major	Last Reviewed:	11/5/2003
Keywords:	kbbug kberrmsg KB295232