Hi Gblackman,
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
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.
For More Information : Microsoft Knowledge Base Article - 237592
http://support.microsoft.com/default.aspx?scid=kb;en-us;237592
Please let me know has this helped You...
Thank You...
Raghu...
This posting is provided "AS IS" with no warranties, and confers no rights.