有了Microsoft的最新强制更新到Office 365，打破了如此多的访问数据库使用桌子
有很多解决方案在那里使用application.ver.vba中的VBA，但这似乎并没有显示出有问题的更新版本。我正在寻找可以使用注册表，DLL或VBA对象属性找到的解决方案。
在访问中 - 文件| 产品信息下的有问题的版本
- 帐户我可以在Office Click-to-run
nofollow noreferrer”> 
或，
- ， ofcess for Business for Business
a href =“ https://i.sstatic.net/e8uyh.png” rel =“ nofollow noreferrer”>
在VBA中，我可以从以下
Debug.Print Application.Version & "." & Application.Build & vbcrlf & Application.ProductCode
16.0.8326
{90160000-000F-0000-0000-0000000FF1CE}
查看msaccess.exe的属性，仅显示相同的应用程序版本
编辑没有运气要么
看
HKEY_LOCAL_MACHINE \ SOFTWORT \ MICROSOFT \ Office \ ClickTorun \ Configuration 仅显示
CurrentVersionToreport = 16.0.8326.2096
With Microsoft's latest forced update to Office 365 that broke so many Access databases using tables ODBC links to server databases, I've been trying to find a way to pull the Office build info while in MS-Access and display that info in a Main form for troubleshooting.
There's many solutions out there that use Application.Version in VBA but that doesn't seem to show the offending update version. I'm looking for a solution that maybe can find it using Registry, DLL or a VBA Object property.
In Access - under File | Account I can see the offending version under
- Product Information in Office Click-To-Run
or,
- About Access in Apps For Business
From VBA I can get the following
Debug.Print Application.Version & "." & Application.Build & vbcrlf & Application.ProductCode
16.0.8326
{90160000-000F-0000-0000-0000000FF1CE}
Looking at the properties of MSAccess.exe only shows the same app versions
EDIT
No luck with registry setting either
Looking at
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Office\ClickToRun\Configuration only shows
CurrentVersionToReport=16.0.8326.2096
发布评论
评论（4）
不幸的是，这并不是一项琐碎的任务，但Colin进行了认真的尝试：
访问 / Office 365 / Windows版本检查
太多代码，无法在此处发布。
This is, unfortunately, not a trivial task, but Colin made a serious attempt:
Access / Office 365 / Windows Version Check
Too much code to post here.
您可以将构建映射到版本。他们是同一件事。
您已经找到了如何获取构建号，
application.build。您可以使用Microsoft Docs上提供的表： https://learn.microsoft.com/en-us/officeupdates/update-history-microsoft365-apps-by-date 。
该版本只是一个较短的代码，因此更容易记忆和通信（较小的更改可能会导致不同的构建数字，但版本编号相同）。
You can map the build to the version. They're the same thing.
You've already figured out how to get the build number,
Application.Build.You can map that using the table provided on Microsoft Docs: https://learn.microsoft.com/en-us/officeupdates/update-history-microsoft365-apps-by-date.
The version is just a shorter code, and thus more easy to memorize and communicate (and minor changes can result in different build numbers but identical version numbers).
有关信息，Gustav提供的旧链接不再维护由Gustav提供的，最终将消失。当前链接为 https：//www.isladogs.co。 UK/Access-Office365-WIN-CHACK/INDEX.HTML
去年做出了坚定的努力，使用VBA/来自注册表/数据库属性等通过各种方法来查找365个每月版本（当前2205），我同意只能通过创建查找表获得版本号。
也许在启动时办公室“手机回家”以检索版本号？我们现在知道，访问可以确定是否应该“打开”某些功能 - 通常用于回避超链接子辅助＆amp＆amp＆amp; amp; #deleted错误是由版本2205触发的
For info, the old link to my Access/Office/Windows version checker provided by Gustav is no longer being maintained and will eventually disappear. The current link is https://www.isladogs.co.uk/access-office365-win-check/index.html
Having made a determined effort last year to find the 365 monthly version (currently 2205) by various methods using VBA / from the registry / database properties etc, I agree that the version number can only be obtained by creating a lookup table.
Perhaps Office 'phones home' at startup to retrieve the version number? We now know that Access does this to determine whether certain features should be 'switched on' or not - a feature that is often used to roll back issues such as the hyperlink subaddress & #DELETED bugs that were triggered by version 2205
Office应用程序未提供关于窗口
上列出的格式的版本号。您需要找到 application.version.version 在所有构建的列表中，具有相应的人类可读版本在MSDN中列出。Office applications don't provide the version numbers in the format listed on the
Aboutwindow. You need to find the Application.Version in the list of all builds with a corresponding human-readable versions listed in MSDN.