Enabling MS Access on Office 365
O365 Business and O365 Business Premium now include MS Access. BUt what is not listed is that Access will only show up if the account is set to receive the Current Channel for software updates. We must switch the channel to Current to obtain MS Access. The default for all installs is deferred.
- DEFERRED CHANNEL gets Access in June 2017
- CURRENT CHANNEL Access is available as of Jan 2017.
Script
Please run the following to change the update channel.
- changeO365channel.bat
setlocal reg query HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Office\ClickToRun\Configuration\ /v CDNBaseUrl if %errorlevel%==0 (goto SwitchChannel) else (goto End) :SwitchChannel reg add HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Office\ClickToRun\Configuration /v CDNBaseUrl /t REG_SZ /d "http://officecdn.microsoft.com/pr/492350f6-3a01-4f97-b9c0-c7c6ddf67d60" /f reg delete HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Office\ClickToRun\Configuration /v UpdateUrl /f reg delete HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Office\ClickToRun\Configuration /v UpdateToVersion /f reg delete HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Office\ClickToRun\Updates /v UpdateToVersion /f reg delete HKEY_LOCAL_MACHINE\SOFTWARE\Policies\Microsoft\Office\16.0\Common\OfficeUpdate\ /f "%CommonProgramFiles%\microsoft shared\ClickToRun\OfficeC2RClient.exe" /update user :End Endlocal
See this page for more info: https://support.microsoft.com/en-us/help/3185078/how-to-switch-from-deferred-channel-to-current-channel-for-the-office-365-suite