PRA: GP Fault Using Find Tool in Datasheet View Form

Article ID: Q115878
Creation Date: 06-JUN-1994
Revision Date: 19-SEP-1996

The information in this article applies to:

Microsoft Access version 2.0

SYMPTOMS

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

When you use the Find tool in a form in Datasheet view, you receive a general protection (GP) fault error message that closes Microsoft Access.

This symptom occurs only when you select a field that meets one of the following conditions before you use the Find tool:

The field's Locked property is set to Yes and its Enabled property is set to No.
The field's TabStop property is set to No.

RESOLUTION

To work around this problem, design your form to simulate Datasheet view. You can do this by setting the form's DefaultView property to Continuous Form and its ViewsAllowed property to Form and by shrinking its detail section to eliminate all white space above and below its controls. Note that this is a preventative measure, not a way to correct the problem.

STATUS

Microsoft has confirmed this to be a problem in Microsoft Access version 2.0. This behavior no longer occurs in Microsoft Access for Windows 95 version 7.0.

MORE INFORMATION

Steps to Reproduce Problem

WARNING: The following steps cause a GP fault. Make sure you save any open work before proceeding.

Start Microsoft Access and open any database.
Import the Customers table from the sample database NWIND.MDB by choosing Import from the File menu, then selecting Microsoft Access.
Create a new form based on the Customers table. Drag all the fields from the field list to the form.
Set the Company Name field's Locked property to Yes and its Enabled property to No.
View the form in Datasheet view.
Select the Contact Title column and then choose the Find tool from the toolbar. Note that the Find tool works correctly.
Select the Company Name column and then choose the Find tool from the toolbar. An application error will occur.

REFERENCES

Microsoft Access "User's Guide," version 2.0 , Chapter 15, "Designing Forms," pages 370-373

THE INFORMATION PROVIDED IN THE MICROSOFT KNOWLEDGE BASE IS PROVIDED "AS IS" WITHOUT WARRANTY OF ANY KIND. MICROSOFT DISCLAIMS ALL WARRANTIES, EITHER EXPRESS OR IMPLIED, INCLUDING THE WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE. IN NO EVENT SHALL MICROSOFT CORPORATION OR ITS SUPPLIERS BE LIABLE FOR ANY DAMAGES WHATSOEVER INCLUDING DIRECT, INDIRECT, INCIDENTAL, CONSEQUENTIAL, LOSS OF BUSINESS PROFITS OR SPECIAL DAMAGES, EVEN IF MICROSOFT CORPORATION OR ITS SUPPLIERS HAVE BEEN ADVISED OF THE POSSIBILITY OF SUCH DAMAGES. SOME STATES DO NOT ALLOW THE EXCLUSION OR LIMITATION OF LIABILITY FOR CONSEQUENTIAL OR INCIDENTAL DAMAGES SO THE FOREGOING LIMITATION MAY NOT APPLY.