How to check microsoft jet engine version

What does deprecated mean? Microsoft recommends, when you develop new applications, that you avoid using these components. Additionally, when you upgrade or modify existing applications, remove any dependency on these components. Let's try this in an organized fashion: Access version s : 97 JET version: 3.

Something like that DAO library version: 3. 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. Si hoc legere scis, nimis eruditionis habes Red Flag This Post Please let us know here why this post is inappropriate.

Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework. The Tek-Tips staff will check this out and take appropriate action. ApplicationClass ; oAccess. OpenCurrentDatabase mdbPath, false, "" ; Microsoft. WriteLine "Microsoft Access 2" ; break; case Microsoft. WriteLine "Microsoft Access 95" ; break; case Microsoft. WriteLine "Microsoft Access 97" ; break; case Microsoft. WriteLine "Microsoft Access " ; break; case Microsoft.

Quit Microsoft. DBEngine ; dao. Property prop in db. Parse prop. GalacticJello GalacticJello Almost - but not quite. Two issues: a Can't assume user has Access installed, only JET, and b the above solution opens up the Access UI and prompts user as to whether to open an "unsafe" file database may contain macros. I tried telling Access it was invisible, but presumably the cloak of invisibility gets lifted if it wants to prompt the user Check out this link to avoid pop up boxes: support.

Thanks for your help - the second solution looks close, but seems to always return "35" regardless of the DB format. While not the answer you seek, another solution would be to just add a property to any database your app opens, and check for your custom "HasBeenUpgraded" property, and if app doesn't find it, just upgrade it, then add the property to it. Application requires Access installed.

Add a comment. If I'd been here before an answer automatically got accepted, you would have had the tick! It's always better to test for the presence of a feature rather than the presence of a particular version. This is completely independent of the version of the data file. I'll have to investigate this further. In a bit Windows environment, you can run an application in the bit mode. The Jet Database Engine was designed to be a general-purpose database engine that's supplied together with Windows.

ACE is provided in both bit and bit architectures. However, only one architecture is allowed on a device. The architecture of ACE must match the architecture of the Office installation on that computer.