Detect Access version from script

[Bruce Hensley]

We have 30,000 MDBs scattered across our intranet created with Access
versions 97, 2000, 2002, and 2003, and using various Jet engines. Some are
secured; some with their own MDW.

We would like to create a script that will check each MDB and report the
version of Access that created it and the version of Jet. Since we don't
know which are secured, and we have so many, we are looking for a method
that does not require the database to be opened ... perhaps something that
will examine the file header.

We will likely follow up with a script that takes some customized actions
(e.g. moving files, triggering emails) based upon the version, so the
commercial products, such as AccVer and Total Access do not appear to fully
fit the need.

Any suggestions would be appreciated.

Thanks,
Bruce

 

[M.L. Sco Scofield]

Have you tried looking at the "Microsoft Office Access 2003 Conversion
Toolkit" at
http://www.microsoft.com/office/ork/2003/journ/accessconvert.htm?

The scanner in it collects a lot of information.

Good luck.

Sco

M.L. "Sco" Scofield, Microsoft Access MVP, MCSD, MCP, MSS, A+
Useful Metric Conversion #17 of 19: 1 billion billion picolos = 1 gigolo
Miscellaneous Access and VB "stuff" at www.ScoBiz.com

 

[Bruce Hensley]

Sco,

Thanks for the tip. We've used it to do the analysis. It took care of my
first request.

However, it doesn't appear to have any tools we can use to script custom
actions for each MDB.

Thanks again for your help.

Bruce