Query Crashing In Access 2007 (1 Viewer)

iworkonline · Sep 14, 2010

I am running the following search query on a table [Par_Client] containing 77195 records

Code:

SELECT [Par-Client].Parent_Name, [Par-Client].CLast, [Par-Client].CFrst
FROM [Par-Client]
WHERE ((([Par-Client].Parent_Name) Like [Forms]![frmSearchParent]![txtName] & "*"));

The application is crashing when I run this.

My program is setup like so.

A form containg the text box and the command button.
Text box [txtName] contains the search string and the code behind command button is

Code:

 DoCmd.OpenQuery ("qrySearchParent")

the sql code is above for the qrySearchParent

I would appreicate any suggestions on improving my code.
Thanks

The_Doc_Man · Sep 14, 2010

When you say "crash" I can think of at least two or three meanings for that term. Can you be a bit more specific about the crash manifestation?

I.e. Blue Screen of Death? "Access encountered an error and must terminate" ? Something else?

And if there is an error code indicated, it would help to know it. HINT: If your "crash" is a case of Access wanting to send an error report, open the report to see the first several lines of that report. It will contain a set of hexadecimal (0x...) codes that will be necessary for proper analysis.

Query Crashing In Access 2007 (1 Viewer)

iworkonline

Registered User.

The_Doc_Man

Immoderate Moderator

Similar threads

Users who are viewing this thread