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

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.

Steps to Reproduce the Problem

New Table

1. Start Access, click Blank Database in the New File task pane, type Test01 in the File name box, and then click Create.
2. Double-click Create table by entering data.
3. Type the following data in the datasheet:

       Field1        Field2
      --------      --------
      Firstone      Firsttwo
      Secondone     Secondtwo
   					

4. On the standard toolbar, click Print Preview.
5. On the View menu, click Design View.
6. In the Save As dialog box, click OK, and then click Yes to allow Access to set a primary key.
7. On the View menu, click Datasheet View, and then click Yes to save the table.
8. In the Microsoft Access problem message dialog box, click Don't Send.

Existing Table

1. Open the database Test01 described in the "New Table" 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.