469,658 Members | 1,680 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,658 developers. It's quick & easy.

Detect Access version from script

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
Nov 13 '05 #1
2 2113
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


Nov 13 '05 #2
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


Nov 13 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

1 post views Thread by DBLWizard | last post: by
9 posts views Thread by Rich | last post: by
9 posts views Thread by Wayne Smith | last post: by
4 posts views Thread by aotemp | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.