Microsoft KB Archive/104914

{|
 * width="100%"|

ACC1x: Crosstab Query with DLL Reference Fails

 * }

Q104914

-

The information in this article applies to:


 * Microsoft Access 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

Issue type : kbbug

Technology :