ACC2000: Deleting Nonexistent Object Returns Error Code 7874 Not 3011

ID: Q237592

The information in this article applies to:
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 <objectname>
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 <objectname>. 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


MORE INFORMATION

Steps to Reproduce Behavior

  1. Open the sample database Northwind.mdb.


  2. Create a module and type the following line in the Declarations section if it is not already there:


    3. 
Option Explicit
  3. Type the following procedure:


    4.  
Sub Test()
   DoCmd.DeleteObject acTable, "XXX"
End Sub
  4. 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.


  5. Repeat steps 1 through 4 in the sample project NorthwindCS.adp and note that you receive the same error message.


Additional query words: prb conversion convert 


Keywords          : kbdta CnvProb CnvVerDif 
Version           : WINDOWS:2000
Platform          : WINDOWS 
Issue type        : kbprb

Last Reviewed: July 23, 1999