AllTables « Access « VBA / Excel / Access / Word






  1. VBA / Excel / Access / Word
  2. Access
  3. AllTables
1.Delete backup tables
2.iterates the AllTables collection, opens each nonsystem table, prints its structure, and then closes the open table.
3.iterates the AllTables collection looking for a table whose name includes the substring "Backup".
4.iterates the AllTables collection to determine if a table is open. If it is, it prompts the user to close it.