Microsoft KB Archive/96991

{|
 * width="100%"|

PRA: GPF When Using ListParameters Method on Database
'Article ID: Q96991

Creation Date: 04-APR-1993

Revision Date: 19-SEP-1996' The information in this article applies to:


 * Microsoft Access version 1.0

SYMPTOMS

Illegally using the ListParameters method on a Database object does not generate a compile-time error as expected, but rather a general protection (GP) fault.

RESOLUTION

The ListParameters method is intended only for use with QueryDef objects.

Use only methods legal for use on the Database object:

Close           CreateDynaset CreateQueryDef  CreateSnapshot DeleteQueryDef  ListTables OpenQueryDef    OpenTable 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.

MORE INFORMATION

In Microsoft Access versions 1.1 and 2.0, you receive the following descriptive compile-time error instead of a GP fault:

Method not applicable for this object Attempting to list parameters for a database object is illegal, but instead of generating the expected compile-time error, Microsoft Access version 1.0 generates a GP fault. For example, the following subroutine causes a GP fault in Microsoft Access version 1.0 instead of a compile-time error: Sub Test Dim db As Database Dim Snap As Snapshot

Set db = CurrentDB Set Snap = db.ListParameters End Sub
 * }

-

"THE INFORMATION PROVIDED IN THE MICROSOFT KNOWLEDGE BASE IS PROVIDED &quot;AS IS&quot; 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." '' ©1997 Microsoft Corporation. All rights reserved. Legal Notices.

''

Additional reference words: 1.00

KBCategory: kbprg

KBSubcategory: PgmObj