ACC2002: Microsoft Access Quits When You Programmatically Switch Views on Open Tables or Queries (295242)

SYMPTOMS

When you use Visual Basic for Applications (VBA) code to switch between views on open tables or queries, you may receive the following error message, and then Microsoft Access quits:

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

When you view the details in the error report, the report states that an error has occurred in Msaccess.exe.

RESOLUTION

If you must change the view of the table or query, you must modify your code to first close the open table or query, and then reopen the table or query for the view that you want.

For the example in the "Steps to Reproduce the Behavior" section later in this article, you can change the code and correct the behavior as follows:

For the Customer Table in Print Preview command button, make the following code changes:
```
DoCmd.Close acTable, "customers"
DoCmd.OpenTable "Customers", acViewPreview
```
For the Switch Customer Table to Design View command button, make the following code changes:
```
DoCmd.Close acTable, "customers"
DoCmd.OpenTable "Customers", acViewDesign
```

MORE INFORMATION

Steps to Reproduce the Behavior

In the Northwind sample database, create a new form.

Add a command button to the form, and then set the following properties:

   Command button
   --------------
   Name: Command1
   Caption: Customer Table in Print Preview
   OnClick: [Event Procedure]

Set the OnClick property of the Command1 command button to the following event procedure:
```
DoCmd.OpenTable "Customers", acViewPreview
					
```

Add another command button to the form, and then set following properties:

   Command button
   --------------
   Name: Command2
   Caption: Switch Customer Table to Design View
   OnClick: [Event Procedure]

Set the OnClick property of the Command2 command button to the following event procedure:
```
DoCmd.OpenTable "Customers", acViewDesign
```
Save the form as Form1.
Open the Form1 form, and then click the Customer Table in Print Preview button.
Switch back to the form without closing the preview of the Customers table, and then click the Switch Customer Table to Design View button.

Note that you receive the error message that is mentioned in the "Symptoms" section of this article, and then Microsoft Access quits.