I am wanting to delete a table in my database if it exists.
I am able to delete the table if it is present but errors if it is not present.
My code so far is
Public Function DelTables()
strFile = "ASCCopyT"**********I need code here that identifies the table***************
If Len(strFile) > 0 Then
DoCmd.DeleteObject acTable, "ASCCopyT"
End If
Thanks for any help you can give.
Wayne
I am able to delete the table if it is present but errors if it is not present.
My code so far is
Public Function DelTables()
strFile = "ASCCopyT"**********I need code here that identifies the table***************
If Len(strFile) > 0 Then
DoCmd.DeleteObject acTable, "ASCCopyT"
End If
Thanks for any help you can give.
Wayne