[AccessD] Version of Jet

Here is some code, I've footled around with awhile ago.
 It only returns the Jet Version and Access Version of the Access 
Program running
but you could adapt to search out all the Jet Versions installed Jet35, 
Jet40 etc.

 From Reinier Olislagers site <reiniero at SEAL.NL>

http://www.xs4all.nl/~rolislag/accver/

It doesn't go back to Jet 1.0, I think you have to search DAO dll 
versions for this
Code  is missing a couple of versions
'Msjet40.dll        4.0.4431.1    Jet 5 SP
'Msjet40.dll        4.0.6218.0    Jet 6 SP
' Msjet40.dll        4.0.8015.0  Jet SP 8
'Here is what I get from Access 2003 Beta 2 or Access 11
'Access: 11.0.4920.5 (unknown Access version)
'Jet: 4.0.7328.0 (UNKNOWN ACCESS VERSION) Using latest SP7.
'I think original Beta 2 came with SP6
'There were a couple of Beta releases of SP7
' there is also Jet SP8, haven't installed yet

The DLL Hell database doesn't list  all Jet Versions
http://support.microsoft.com/default.aspx?scid=http%3a%2f%2fsupport.microsoft.com%2fservicedesks%2ffileversion%2fdllinfo.asp&fp=1




Dave Sharpe wrote:

>Rocky
>
>Page
>http://support.microsoft.com/default.aspx?kbid=239114
>
>Entitled
>How To: Obtain the Latest Service Pack for the Microsoft Jet 4.0 Database
>Engine
>
>Contains a section
>How to Determine the Current Service Pack Level of Jet 4.0
>Use the following steps to determine the Jet 4.0 service pack level that is
>currently installed on your computer.
>
>Note Because there are several versions of Microsoft Windows, the following
>steps may be different on your computer. If they are, see your product
>documentation to complete these steps.
>
>On the Start menu, click Search.
>
>In the Search Results pane, click All files and folders under Search
>Companion.
>
>In the All or part of the file name box, type msjet40.dll, and then click
>Search.
>
>In the list of files, right-click the Msjet40.dll file that is located in
>the Windows\System32 (or Windows\System) folder, and then click Properties.
>
>Click the Version tab, and then use the following table to determine the
>current Jet 4.0 service pack level:
>
>Msjet40.dll    Version Jet 4.0 Service Pack Level
>4.0.2927.4     Service Pack 3 (SP3)
>4.0.3714.7     Service Pack 4 (SP4)
>4.0.4431.1     or 4.0.4431.3 Service Pack 5 (SP5)
>4.0.6218.0     Service Pack 6 (SP6)
>4.0.6807.0     Service Pack 6 (SP6) shipped only with Windows Server 2003
>4.0.7328.0     Service Pack 7 (SP7)
>4.0.8015.0     Service Pack 8 (SP8)
>
>I hope that this helps.
>
>Dave
>
>
>----- Original Message ----- 
>From: "Rocky Smolin - Beach Access Software" <bchacc at san.rr.com>
>To: <AccessD at databaseadvisors.com>
>Sent: Saturday, March 20, 2004 10:07 AM
>Subject: [AccessD] Version of Jet
>
>
>Dear List:
>
>How do I determine which versions of Jet are loaded on my system?
>
>Thanks in advance,
>
>Rocky Smolin
>Beach Access Software
>http://www.e-z-mrp.com
>
>  
>

-- 
Marty Connelly
Victoria, B.C.
Canada