Microsoft KB Archive/104914

From BetaArchive Wiki

ACC1x: Crosstab Query with DLL Reference Fails


The information in this article applies to:

  • Microsoft Access 1.0


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.


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.


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.


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
Issue type : kbbug
Technology :

Last Reviewed: November 4, 2000
© 2001 Microsoft Corporation. All rights reserved. Terms of Use.