I'm running a module in access to delete a table each day but I have more than one table that needs to be deleted
the code is;
Public Function DeleteTable()
Dim tdf As TableDef
For Each tdf In CurrentDb.TableDefs
If tdf.Name = "B0101" Then
DoCmd.DeleteObject acTable, tdf.Name
but I need to delete "B0101", "B0102", "B0103" etc....
can someone show me how to add the other tables into the code?