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

[David Schofield]

Hi
Delayed reply! I have been looking at some questions to which there
have been no replies.

Maybe you could use Inno or modify the code listed at
http://www13.brinkster.com/vincenzog...t.asp?idart=75
David
On 9 Nov 2004 08:12:05 -0800, ba********@usa.net (Bruce Hensley)
wrote:

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

[David Schofield]

Hi
Oops, this just gives the exe versions.

You could use LISTMDB
(see http://www.aylott.com.au/software.htm)
but as this is priced on a per-workstation basis this would not be
cheap. I don't know whether this does in fact open each database.
David
On 21 Nov 2004 08:22:11 -0600, d.***************@blueyonder.co.uk
(David Schofield) wrote:

Maybe you could use Inno or modify the code listed at
http://www13.brinkster.com/vincenzog...t.asp?idart=75
David
On 9 Nov 2004 08:12:05 -0800, ba********@usa.net (Bruce Hensley)
wrote:

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