ACCESS - VBA Function - Does a table exists
Paste this into your module.
Code:
Function table_exists(tablename)
found = False
For Each Item In CurrentDb.TableDefs
If Item.Name = tablename Then
found = True
Exit For
End If
Next
table_exists = found
End Function
Then execute like this
Code:
Sub test()
If table_exists("tblchests") Then MsgBox "it works"
End Sub
