Array

[klwu]

Hey, is there a way to get the full list of tables in the database by using VBA? I am trying to do a backup function, where I want the database to fetch all the table names and put them into an array, to export them one by one to the backup file........hope you guys understands me.....thanks in advance

 

[pbaldy]

This will get all the names.

  Dim db                 As DAO.Database
  Dim td                 As DAO.TableDef

  Set db = CurrentDb()

  For Each td In db.TableDefs 
    Debug.Print td.Name
  Next td

 

[raskew]

Hi -

Take a look at this freeware from Peter's Software. It works great!

Bob