Microsoft KB Archive/295217

= ACC2002: Access Quits When You Switch from Print Preview to Design View and then to Datasheet View =

Article ID: 295217

Article Last Modified on 11/5/2003

-

APPLIES TO


 * Microsoft Access 2002 Standard Edition

-



This article was previously published under Q295217



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

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



SYMPTOMS
When you switch from Print Preview to Design view and then to Datasheet view, Microsoft Access may quit unexpectedly. This behavior occurs when either of the following conditions are true:
 * You create a new table, open it in Print Preview before saving it, switch to Design view, and then switch to Datasheet view.

- or -
 * You open a previously saved table in Print Preview, switch to Design view and delete one or more fields, and then switch to Datasheet view.



RESOLUTION
To prevent this behavior, return to and close Print Preview before you switch to Design view.



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



MORE INFORMATION
The sequence of events that leads to Access quitting in this fashion is not common, but it may occur particularly in the case of a new table that has not yet been saved. It is less usual to change a table's design while it is open in Print Preview. In either case, by closing Print Preview before entering Design view, you allow Access to continue to function normally.

This behavior occurs when you delete fields from existing tables that are open in Print Preview, but not when you add fields. It does not occur with Access projects.

New Table
 Start Access, click Blank Database in the New File task pane, type Test01 in the File name box, and then click Create. Double-click Create table by entering data.  Type the following data in the datasheet:    Field1        Field2 Firstone     Firsttwo Secondone    Secondtwo  On the standard toolbar, click Print Preview. On the View menu, click Design View.</li> In the Save As dialog box, click OK, and then click Yes to allow Access to set a primary key.</li> On the View menu, click Datasheet View, and then click Yes to save the table.</li> In the Microsoft Access problem message dialog box, click Don't Send.</li></ol>

Existing Table

 * 1) Open the database Test01 described in the &quot;New Table&quot; section.
 * 2) In the Database window, select Table1, and then click Print Preview on the standard toolbar.
 * 3) On the View menu, click Design View.
 * 4) Right-click Field1, and then click Delete Rows on the shortcut menu.
 * 5) Click Yes to confirm the deletion, and then click Yes again to save the table.
 * 6) In the Microsoft Access problem message dialog box, click Don't Send.

Additional query words: pra

Keywords: kbbug kbpending KB295217

-

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

© Microsoft Corporation. All rights reserved.