How to discover what Access files are in your org
I got this request from a customer who is trying to analyze their environment as it pertains to Access and Excel files:
Can we use WSH and VBScript to get this type of basic information out of files in an automated fashion? Both MS Access and Excel have a well defined object model i.e. it should be easy to write a script that opens the file, queries the various collection objects, and dumps the contents (e.g. Table Names in Access, Pivot Table objects in excel, Data source names in either etc for Excel and Access 2000)?
The Office migration planner has some really good tools for understanding what is in your organization. Here is a description of the tool:
The Office Migration Planning Manager (OMPM) is a collection of tools that enables you to prepare your environment for migration to the 2007 Microsoft Office system. OMPM checks for, and reports on, file properties to help you analyze your environment and determine any issues that you might experience converting from Office 97-Office 2003 file formats to the new 2007 Office system file format.