ACC2000: Deleting Nonexistent Object Returns Error Code 7874 Not 3011

• Microsoft Access 2000

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>

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 

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:




Option Explicit 

3. Type the following procedure:




 
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