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]

Re: Detect Access version from script

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/isxart.asp?idart=75

David


On 9 Nov 2004 08:12:05 -0800, baphensley@usa. net (Bruce Hensley)
wrote:
[color=blue]
>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[/color]

[David Schofield]

Re: Detect Access version from script

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.REMOVEschofie ld@blueyonder.c o.uk
(David Schofield) wrote:
[color=blue]
>
>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, baphensley@usa. net (Bruce Hensley)
>wrote:
>[color=green]
>>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[/color]
>[/color]