deleting object only if it exists 1

[jommyjet]

I imagine this is very simple. I want to delete the table if it exists.
I bet it's something similar to this

If IsObject(updateresourcelist) = True Then
DoCmd.DeleteObject acTable, "resourcelist"
Else
End If

Thanks for the help. Also, as this being easy, can anyone recommend a good resource book. I biought a VBA handbook and it reads like garbage

 

[mpastore]

Sub delete_table()
On Error GoTo Err_delete_table
CurrentDb.Execute ("drop table table1&quot

Exit Sub

Err_delete_table:
Debug.Print "Table not found"


End Sub

 

[MK10]

Hi mpastore,

You make it seem so easy.

jommyjet, what's the problem with saying thanks to mpastore.

Babs

 

[jommyjet]

thank you mpastore, because you are helpful, not because babs recommends it