ACC1x: Crosstab Query with DLL Reference Fails

 Last reviewed: May 14, 1997
Article ID: Q104914
The information in this article applies to:
  • Microsoft Access version 1.0

SYMPTOMS

A crosstab query that calls a dynamic link library (DLL) from one of the FormWizards results in the error message 

   GPF in MSABC100.DLL at 0004:7BBC.

CAUSE

DLL functions called from forms, macros, or queries that are opened by Access Basic code cause this problem.

Note that the financial functions in Microsoft Access call DLLs and thus frequently cause this problem. The problem occurs when you attempt to use the ListFields method on a crosstab query that calls a DLL from the wizard's Access Basic code. This problem can also be encountered when you are referencing a crosstab query that calls a DLL from a CreateDynaset method.

RESOLUTION

The workaround for this problem is to put the function contained in the DLL into an Access Basic function. Then, call the Access Basic function instead of calling the DLL.

STATUS

Microsoft has confirmed this to be a problem in Microsoft Access version 1.0. This problem was corrected in Microsoft Access version 1.1.

Keywords : kbusage QryCross
Version : 1.0
Platform : WINDOWS
Hardware : X86
Issue type : kbbug
Resolution Type : kbworkaround

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.

Last reviewed: May 14, 1997
© 1998 Microsoft Corporation. All rights reserved. Terms of Use.