My problem is:
I am doing an import. Ok, no problem, the thing is after this import sometimes some tables are generated, the names of the tables are Output_ImportErrorsX, where X is a number. I want to delete this tables in VBA. I know I can do it with DoCmd.DeleteObject table, name
But the problem is that I want to know in runtime if these tables were generated and delete all of them, more or less, like this:
i = 0
For i=0 until number of tables which start with Output_ImportErrors
DoCmd.DeleteObject table, "Output_ImportErrors" & i
I don't know how to find out in runtime if these tables exist and how many they are.