ACC: GP Fault Changing RecordSource on a Filtered Datasheet

• Microsoft Access versions 1.0, 1.1, 2.0

SYMPTOMS

Moderate: Requires basic macro, coding, and interoperability skills.

When you apply a filter directly from the Filter window to a form open in Datasheet view, and then try to change the form's record source, you may receive a general protection (GP) fault error message.

RESOLUTION

Close the Filter window before applying the filter to the form.

STATUS

Microsoft has confirmed this to be a problem in Microsoft Access versions 1.x and 2.0. This behavior no longer occurs in Microsoft Access version 7.0.

MORE INFORMATION

Steps to Reproduce Problem

1. Open the sample database NWIND.MDB.



2. Select the Customers table in the Database window and then choose Copy from the Edit menu.



3. From the Edit menu, choose Paste. Type Cust in the Table Name box, and then choose the OK button.



4. Open the Customers form in Datasheet view.



5. From the Records menu, choose Edit Filter/Sort.



6. In the Filter window, drag the Customer ID field from the field list to the Field row in the first column.



7. In the Criteria row in the first column, type ALFKI.



8. Click the Apply Filter/Sort button on the toolbar. Do not close the Filter window.



9. View the form in Design view. Change its RecordSource property from the Customers table to the Cust table. You receive a GP fault error message.

REFERENCES

For more information about applying filters, search for "Apply Filter/Sort," and then "Edit Filter/Sort, Apply Filter/Sort Commands (Records Menu)" using the Microsoft Access Help menu.

Additional query words: gpf sheet

Keywords : kbenv kberrmsg
Version : 1.0 1.1 2.0
Platform : WINDOWS
Issue type : kbbug