Microsoft KB Archive/237592

= ACC2000: Deleting Nonexistent Object Returns Error Code 7874 Not 3011 =

Article ID: 237592

Article Last Modified on 6/29/2004

-

APPLIES TO


 * Microsoft Access 2000 Standard Edition

-



This article was previously published under Q237592



Moderate: Requires basic macro, coding, and interoperability skills.

This article applies only to a Microsoft Access database (.mdb).



SYMPTOMS
When you use the DeleteObject method to programmatically delete an object that does not exist, you may receive the following error message:

Run-time error '7874':

Microsoft Access can't find the object

Under the same circumstances, earlier versions of Access display the following error message:

Run-time error '3011':

The Microsoft Jet database engine could not find the object. Make sure the object exists and that you spell its name and the path name correctly.



CAUSE
Microsoft Access 2000 provides a native OLE DB user and programming interface that enables you to access a Microsoft Access database, a Microsoft SQL Server database, and other data sources. Because error code 3011 is specific to the Jet database engine, the error code has been changed to comply with the other data sources.



RESOLUTION
If you have implemented error checking that checks for conditions where the error number = 3011, modify the error checking to reference the number returned in Access 2000. For example, replace MyErrorCheck: If Err.Number = 3011 Then ' Do something here End If with: MyErrorCheck: If Err.Number = 7874 Then ' Do something here End If



Steps to Reproduce Behavior
 Open the sample database Northwind.mdb.  Create a module and type the following line in the Declarations section if it is not already there: Option Explicit   Type the following procedure: Sub Test DoCmd.DeleteObject acTable, "XXX" End Sub   To test this function, type the following line in the Immediate window, and then press ENTER:

Test Note that you receive the error message mentioned in the "Symptoms" section.  Repeat steps 1 through 4 in the sample project NorthwindCS.adp and note that you receive the same error message.</li></ol>

Additional query words: prb conversion convert run time error 7874 Run-time error 3011

Keywords: kbprb KB237592

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.