{"id":7265,"date":"2022-06-05T14:00:03","date_gmt":"2022-06-05T14:00:03","guid":{"rendered":"https:\/\/www.samlogic.net\/blog\/?p=7265"},"modified":"2022-06-11T16:02:27","modified_gmt":"2022-06-11T16:02:27","slug":"how-to-test-if-a-specific-version-of-access-is-installed","status":"publish","type":"post","link":"https:\/\/www.samlogic.net\/blog\/2022\/06\/how-to-test-if-a-specific-version-of-access-is-installed\/","title":{"rendered":"How to test if a specific version of Access is installed"},"content":{"rendered":"

\"LogotypeIn this blog post<\/a> we described how to check if Microsoft Access is installed in a computer by using script code in Visual Installer<\/a>. But if you want to check if a specific version<\/em> of Access is installed. Is it possible?<\/p>\n

Yes. It is. It is possible to check if a specific version of Access is installed in a computer. To achieve this, you can extend this conditional test:<\/p>\n

IF ACCESS_INSTALLED<\/strong><\/p>\n

with a version number, like this:<\/p>\n

IF ACCESS(15)_INSTALLED<\/strong><\/p>\n

In the example above, Visual Installer will check if Access version 15<\/strong> (Access 2013) is installed. The conditional test gives True if Access version 15 is installed and False if it is not.<\/p>\n

How to check for a specific bitness of Access<\/strong><\/span>
\n\"SymbolicIt is also possible to check if a specific bitness (32 or 64 bit) of Microsoft Access is installed in a computer – in addition to the version number. For example, to check if a 64 bit version of Access 2013 (version 15) is installed, you can use the following script:<\/p>\n

IF ACCESS(15)_64BIT_INSTALLED<\/strong><\/p>\n

If you instead want to check if a 32 bit version of Access 2013 is installed, you can use the following script line:<\/p>\n

IF ACCESS(15)_32BIT_INSTALLED<\/strong><\/p>\n

If you want to check which bitness of Access that is installed, regardless of the version number, there is another conditional test than you can use. For example, to check if any 64 bit Access is installed in the computer, you can use the following conditional test:<\/p>\n

IF ACCESSBIT=64<\/strong><\/p>\n

In the same way you can check if any 32 bit Access is installed in the computer, by using this conditional test:<\/p>\n

IF ACCESSBIT=32<\/strong><\/p>\n

Examples<\/strong><\/span>
\nBelow are some script examples that shows how to use the conditional tests:<\/p>\n

\/\/ Example 1 \u2013 Tests if Microsoft Access 2013 is installed in the system<\/span>
\nIF<\/span> ACCESS(15)_INSTALLED
\n\u00a0 RUN<\/span> %DESTDIR<\/span>\\Install-Access2013-Tools.exe
\nEND IF<\/span>
\n   <\/span>
\n\/\/ Example 2 \u2013 Tests if a 32 bit version of Microsoft Access 2013 is installed in the system<\/span>
\nIF<\/span> ACCESS(15)_32BIT_INSTALLED
\n\u00a0 RUN<\/span> %DESTDIR<\/span>\\Install-Access2013-32bit-Tools.exe
\nEND IF<\/span>
\n   <\/span>
\n\/\/ Example 3 \u2013 Tests if any 32 bit version of Microsoft Access is installed in the system<\/span>
\nIF<\/span> ACCESSBIT=32
\n\u00a0 RUN<\/span> %DESTDIR<\/span>\\Install-Access-32bit-Tools.exe
\nEND IF<\/span>\n<\/div>\n

In this blog post we described how to check if Microsoft Access is installed in a computer by using script code in Visual Installer. But if you want to check if a specific version of Access is installed. Is it possible? Yes. It is. It is possible to check if a specific version of Access … <\/p>\n

Continue reading “How to test if a specific version of Access is installed”<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":[],"categories":[10,15],"tags":[],"_links":{"self":[{"href":"https:\/\/www.samlogic.net\/blog\/wp-json\/wp\/v2\/posts\/7265"}],"collection":[{"href":"https:\/\/www.samlogic.net\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.samlogic.net\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.samlogic.net\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.samlogic.net\/blog\/wp-json\/wp\/v2\/comments?post=7265"}],"version-history":[{"count":39,"href":"https:\/\/www.samlogic.net\/blog\/wp-json\/wp\/v2\/posts\/7265\/revisions"}],"predecessor-version":[{"id":7309,"href":"https:\/\/www.samlogic.net\/blog\/wp-json\/wp\/v2\/posts\/7265\/revisions\/7309"}],"wp:attachment":[{"href":"https:\/\/www.samlogic.net\/blog\/wp-json\/wp\/v2\/media?parent=7265"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.samlogic.net\/blog\/wp-json\/wp\/v2\/categories?post=7265"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.samlogic.net\/blog\/wp-json\/wp\/v2\/tags?post=7265"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}

  
\nAccess version numbers<\/strong><\/span>
\nIn this blog post<\/a> you will find a list with available version numbers for some of the conditional tests described above.<\/p>\n","protected":false},"excerpt":{"rendered":"