Welcome to MSDN Blogs Sign in | Join | Help

Microsoft Access Team Blog

Get product announcements, tips and tricks, and news directly from the team @ Microsoft.
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.

Enjoy!

Posted: Saturday, March 21, 2009 8:14 AM by Clint Covington
Filed under:

Comments

Tony D'Ambra said:

I have two free tools on my web site that providedifferent Access file information:

Find Databases Wizard: The Wizard finds all the MS Access files in the location you select and classifies each file by Access version, lists all the files found in the location, and saves the data in a text-delimited file.

Table Links and Connections Manager: The Connection Manager will find all the Microsoft Access files in the location you select and a report will display all table links and base string connections, including dependents of, and any connect errors grouped by: Jet Version, File Type, Linked Database Paths and linked tables, and Base Connection Strings. Separate reports are produced for .md* and .ad* files.

Download from http://www.aadconsulting.com/freeaddins.html

# March 22, 2009 1:39 AM

Donn Edwards said:

Why is there no 64-bit version of Access 2007? Surely Access would benefit from the extra RAM?

# March 23, 2009 11:01 AM

grovelli said:

There's going to be one for Access 14, according to http://blogs.zdnet.com/Bott/?p=742

# March 23, 2009 11:14 AM

Clint Covington said:

Donn,

Thanks for your suggestion. Unfortunately, I can't comment more about it as we haven't started talking publicly about what is in or out of the next version. Stay tune...

# March 23, 2009 11:16 AM

Andrew Plaisted said:

I would love to see a 64 bit version of MS Access.

Does the OMPM use WSH or VBScript to get information out of files in an automated fashion?  I do not think so but as I have never used the OMPM I can not say for sure.

I think some of the emails are looking for something that would grab the information and make it available in a Table for current projects, will the OMPM do that?

# March 24, 2009 12:22 AM

Microsoft Access Team Blog said:

Today’s guest writer is Shawn Sullivan from the Office Shared team. I have asked him to talk about the

# June 9, 2009 9:01 PM
New Comments to this post are disabled
Page view tracker