How to check which version of MS JET?

[tsmits1975]

Hi there,

I would like to know which version of MS JET I have currently installed. Is there any way to find this out?

Thanks.

 

[Golom]

In DAO

Debug.Print "JET Version: " & DAO.DBEngine.Version

 

[THWatson]

You can also do a search, using msjet*.dll as the search criteria.

Tom

 

[PHV]

Like this ?
MsgBox "Database Jet version = " & CurrentDB.Version

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[ZmrAbdulla]

which one is correct?
[tt]
Debug.Print "JET Version: " & DAO.DBEngine.Version
JET Version: 3.6

Debug.Print "Database Jet version: " & CurrentDB.Version
Database Jet version: 4.0
[/tt]

________________________________________________________
Zameer Abdulla
Help to find Missing people
Do not cut down the tree that gives you shade.

 

[Ed2020]

Taken from MS Access help:

"On the DBEngine object, returns the version of DAO currently in use. On the Database object, returns the version of Jet that created the .mdb file."

Ed Metcalfe.

Please do not feed the trolls.....

 

[psemianonymous]

There's essentially only two modern versions of JET and thus two DAO libraries. The only thing you have to know is that the library version/JET engine versions aren't necessarily the same and don't mean the same thing.

Let's try this in an organized fashion:

Access version(s): 97
JET version: 3.5? Something like that...
DAO library version: 3.5

Access version(s): 2000, 2002 (XP), 2003
JET version: 4.0
DAO library version: 3.6

 

[CosmoKramer]

Go to:
Control Panel,
Administrative Tools,
Data Sources (ODBC),
then the Drivers tab.

Scroll down to find Microsoft Access Database and look in the version column.

Just because a PC has a certain version of Access on it doesn't necessarily mean the correct Jet library is there. I've seen instances where installing subsequent applications could overwrite the Jet .dll with an older/newer version......

Si hoc legere scis, nimis eruditionis habes