I need to document and build a table with the names of all the Access 2007 Reports within a whole company. The databases (around 30 or so) are located in a folder and then subfolders per department. There are some databases...like copies of database or backups of databases that I would like to skip.
Starting with a new blank Access Database, Is there a way, through code to loop through the databases and pull the report names building a new table with the names in the new access database? I would need to get their names, database name and possibly the location of the database.