Microsoft KB Archive/295232

= ACC2002: Access Quits When You Sort a Table While Renaming a Column =

Article ID: 295232

Article Last Modified on 11/5/2003

-

APPLIES TO


 * Microsoft Access 2002 Standard Edition

-



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.



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



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



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



Steps to Reproduce the Problem
 Start Access and open a new database.  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.</li> Rename column &quot;Col1&quot; as &quot;Col2.&quot; Do not press ENTER.</li> 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 &quot;Symptoms&quot; section of this article.</li></ol>

Additional query words: pra

Keywords: kberrmsg kbbug KB295232

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.