Run-time error '7874'

[BLeslie88]

Doing a loop to remove error import table:

Example:
"CONTACTS1_ImportErrors"

DoCmd.DeleteObject acTable, "CONTACTS" & myNum & "_ImportErrors"

This has been working well - now today - suddenly there is no error with one table import... So I get title error message. "Run-time error '7874'"

Is there anyway to bypass this exception when it occurs without removing the line of code?

I did search forums - there was no obvious answer though similar errors.

Thanks,
Brian
:banghead:

 

[MikeLeBen]

Well yes, you could bypass it although I would look into the matter to fix your code so it's error free.

Anyway, you'd use an error handler like this to bypass it:

'....code

On Error GoTo errHandler

'...more code

Exit Sub

errHandler:
if err.number = 7874 then
resume next
Else
msgbox Err.Number & " - " & err.description
End if

End Sub

 

[vbaInet]

There's really no point in deleting the table to be honest. Best delete the data instead. But it worries why you're needing to do this in the first place?

What exactly is the error message? There are hundreds of error codes out there and we don't know it all.

 

[BLeslie88]

It is a text file - delimited file - that there is headings among other lines that generate errors on every import as I have some forced field specifications...

This causes import errors.

I am not the one maintaining it and do not want accumilated error tables - so I do not see how not doing this wouldn't be efficient.

 

[BLeslie88]

MikeLeBen worked out fine thinks!

 

[vbaInet]

I missed the fact that these were import error tables. Have a look at this:

http://support.microsoft.com/kb/210307