MS访问中的链接表显示#Deleted在所有行和列中
今天，我遇到了一个问题，其中MS Access版本2022（构建14931.20392）开始在链接表中的所有行和列显示到SQL Server 2012数据库中的所有行和列的“ #deleted”。
在数据库服务器上没有进行更改。我们不确定何时更新了用户的MS访问副本，但我们确实知道它是运行2022版。
权限很好。
使用“ SQL Server”驱动程序的SQL Server的用户DNS用于连接。
我切换到“ SQL本地客户端11”驱动程序，重新链接了表，并有相同的错误。
我让用户重新链接访问中的表，也没有帮助。
我无法使用相同的访问数据库运行访问版本2018重新创建同一问题。
I ran into an issue today where MS Access version 2022 (Build 14931.20392) started just showing "#Deleted" for all rows and columns in a linked table to a SQL Server 2012 database.
No changes were done on the database server. We are not sure when the user's copy of MS Access was updated but we do know it is running version 2022.
Permissions were good.
A user DNS to the SQL Server was used to connect using the "SQL Server" driver.
I switched to the "SQL Native Client 11" driver, relinked the tables, and got the same error.
I had the user relink the tables in Access as well as refresh with no help.
I could not recreate this same issue with the same Access database running Access version 2018.
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（3）
修复！！我们能够通过安装“ SQL Server的Microsoft ODBC驱动程序17”并重新创建访问连接到SQL Server使用的ODBC DSN来解决问题。创建DNS后，将桌子重新链接并工作。
可以肯定地解决了我们的问题，并在其他几个工作站工作。我只是在这里发布此信息，因为我没有在此问题上找到任何有用的信息。我只是希望帮助下一个遇到同一问题的人。
The FIX!! We were able to fix the issue by installing "Microsoft ODBC Driver 17 for SQL Server" and recreating the ODBC DSN used by access to connect to the SQL server. Once the DNS was created, the tables were relinked and worked.
This for sure fixed our issue and worked on several other workstations. I am just posting this here because I had not found any helpful information on this issue. I just hope to help the next person running into this same issue.
这是一个已知的错误，最近是固定的。
解决方法（在大多数情况下）是倾倒传统的SQL驱动程序，并采用本地驾驶员（如本机17上方所述）。
据我所知，根据您的更新流（从Office 365），该修复程序在我编写时已被部署。但是，对于某些人来说，上周确实给某些人造成了麻烦。
This is a known bug, and was recent fixed.
The workaround (in most cases) was to dump the legacy sql driver, and adopt a native driver (such as noted above native 17).
From what I know, depending on your update stream (from office 365), the fix has been deployed as I write this. However, for some, the last week did cause trouble for some.
解决..我的“删除”问题。使用链接管理器，我通过我的MS Access Frontend应用程序中的ODBC 11重新链接了SQL Server的所有表。这纠正了我的问题
Fix.. For my "delete" issues. With Link Manager I relinked all the tables for SQL SERVER through ODBC 11 in my MS Access frontend app. This corrected my problem