ACC1x: Crosstab Query with DLL Reference Fails

ID: Q104914

The information in this article applies to:

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

Last Reviewed: March 27, 1999