ACC97: Error Creating or Running a Query When Criteria Is All Question Marks

Article translations Article translations
Article ID: 239106 - View products that this article applies to.
This article was previously published under Q239106
This article has been archived. It is offered "as is" and will no longer be updated.
Novice: Requires knowledge of the user interface on single-user computers.

Expand all | Collapse all

On This Page

SYMPTOMS

When you try to create or run a query, you may receive one or more of the following error messages.

In Microsoft Windows 95 or 98, you may receive an error similar to the following:
This program has performed an illegal operation and will be shut down.

If the problem persists, contact the program vendor.
When you click Details (on Microsoft Windows Millennium Edition, press ALT+D), you receive the following message:
MSACCESS caused an invalid page fault in MSJET35.DLL at 015f:040371dd.
NOTE: The actual memory address may vary.

After you close the first error message, you may see an error similar to:
This program has performed an illegal operation and will be shut down.

If the problem persists, contact the program vendor.
When you click Details (on Microsoft Windows Millennium Edition, press ALT+D), you receive the following message:
MSACCESS caused an invalid page fault in SSSCC.DLL at 015f:60567702.
NOTE: The actual memory address may vary.

In Microsoft Windows NT, you may receive an error similar to the following:
An application error has occurred and an application error log is being generated.

MSACCESS.exe
Exception: access violation (0xc0000005), Address: 0x040371dd
NOTE: The actual memory address may vary.

In Microsoft Windows 2000, you may receive an error similar to the following:
MSACCESS.exe has generated errors and will be closed by Windows. You will need to restart the program.

An error log is being created.

CAUSE

You created a query in which the only character in the Criteria row is one or more question marks (?).

RESOLUTION

Install the Microsoft Jet 3.5 SP3 update. For additional information about how to obtain the Microsoft Jet 3.5 SP3 update, please click the article number below to view the article in the Microsoft Knowledge Base:
172733 ACC97: Updated Version of Microsoft Jet 3.5 Available for Download

STATUS

Microsoft has confirmed that this is a problem in the Microsoft products that are listed at the beginning of this article.

MORE INFORMATION

Steps to Reproduce Problem

  1. Open the sample database Northwind.mdb.
  2. Create the following query based on the Customers table:
       Query: qryQuestion
       ------------------
       Type: Select Query
    
       Field: CustomerID
       Table: Customers
       Criteria: ???
    					
  3. On the Query menu, click Run. Note that you receive one of the errors mentioned in the "Symptoms" section.

Properties

Article ID: 239106 - Last Review: October 21, 2013 - Revision: 3.1
APPLIES TO
  • Microsoft Access 97 Standard Edition
Keywords: 
kbnosurvey kbarchive kbbug kberrmsg kbpending KB239106

Give Feedback

 

Contact us for more help

Contact us for more help
Connect with Answer Desk for expert help.
Get more support from smallbusiness.support.microsoft.com