ACC2: GP Fault Creating Report Based on Query with SubqueryID: Q121898
|
Moderate: Requires basic macro, coding, and interoperability skills.
When you create a report based on a parameter query that contains a
subquery, you receive the following general protection (GP) fault error
message:
MSACCESS caused a General Protection Fault in module MSAJT200.DLL at <address>
Convert your parameter query to a make-table query, and then run the query to create a new table. Use the new table as the record source for the report rather than the parameter query.
This problem no longer occurs with the Microsoft Jet database engine
version 2.5, which is available with the Microsoft Access version 2.0
Service Pack. For information about how to obtain the Service Pack,
please see the following article in the Microsoft Knowledge Base:
Q122927 WX1124: Microsoft Access Version 2.0 Service Pack
Query: Query1
-------------------------------------------------------
Field: Category ID
Table: Categories
Field: Supplier ID
Table: Products
Criteria: [Enter a Supplier ID]
Field: Cat: (SELECT [Category Name] FROM [Categories] _
WHERE [Products].[Category ID]=_
[Categories].[Category ID])
Additional query words: gpf jet25 jet 2.5
Keywords : kberrmsg kbusage RptProb
Version : 2.0
Platform : WINDOWS
Issue type : kbbug
Last Reviewed: April 8, 1999