SQL Server后端，MS Access前端:连接 [英] SQL-Server Backend, MS Access Frontend: Connection

问题描述

通过ODBC从MS Access连接到SQL Server(不一定). 我想将Access表单绑定到SQL Server数据.能够动态过滤服务器上的记录集(与传递查询一样)将是很棒的选择，但我想避免表格是只读的.我非常感谢您的任何建议.提前致谢.我在这里找到了类似的问题，但没有找到我想要的答案.

我曾处理以下文章:
使用SQL Server后端访问DB-堆栈溢出
导入或链接到SQL Server数据-Access-Office
Microsoft正在与ODBC进行本地关系数据访问-常见问题解答
Microsoft正在与ODBC进行本地关系数据访问-Microsoft SQLNCli团队博客-网站主页-MSDN博客
优化链接到SQL Server的Microsoft Office Access应用程序
性能-最佳实践SQL Server_Access连接-堆栈溢出
sql server-如何使直通_ passthru查询可编辑_-堆栈溢出
sql server-SQL和MS访问-表单上数据的过滤-Stack Overflow
使用Access为SQL Server构建前端-TechRepublic
Wiley.Microsoft.SQL.Server.2008.Bible.Aug.2009_Excerpt_Access
访问作为前端，SQL Server作为后端-代码日志
我找不到答案，但是我可能忽略了它.好吧，我一定有.

Connecting from MS Access to SQL Server via ODBC (not necessarily). I would like to bind my Access forms to SQL Server data. It would be great being able to dynamically filter recordsets on the server (as with pass through queries) but I would like to avoid the forms being read-only. I am very grateful for any suggestions. Thanks in advance. I have found similar questions here but not the answer that I am looking for.

I worked with following articles:
Access DB with SQL Server Back End - Stack Overflow
Import or link to SQL Server data - Access - Office
Microsoft is Aligning with ODBC for Native Relational Data Access - FAQ
Microsoft is Aligning with ODBC for Native Relational Data Access - Microsoft SQLNCli team blog - Site Home - MSDN Blogs
Optimizing Microsoft Office Access Applications Linked to SQL Server
performance - Best Practice SQL Server_Access connections - Stack Overflow
sql server - How to make a passthrough _ passthru query editable_ - Stack Overflow
sql server - SQL and MS access- filtering of the data on the form - Stack Overflow
Using Access to build a front end for SQL Server - TechRepublic
Wiley.Microsoft.SQL.Server.2008.Bible.Aug.2009_Excerpt_Access
Access as the front end and sql server as the backend - Stack Overflow

I could not find the answer, but I might have overlooked it. Well I must have.

推荐答案

直通查询永远不会为您提供MS Access mdb和accdb中的只读数据.您无法采取任何措施来改变这种状况.因此，您将必须以您选择的方式解决该限制.一种方法是创建一个本地表来保存传递数据，并将表单绑定到THAT数据.然后它将是可编辑的.然后，您必须创建一种机制，以将对本地数据所做的更改推回到其原始源.这涉及很多繁重的工作，但完全可行.您可以获得传递的速度和精度，但是却失去了实时编辑的出色功能，必须对其进行编码.或者，您可以使用ODBC链接表和通过ODBC链接到索引视图的Access链接表，并获得实时编辑的能力，但是却失去了传递的速度和精度.

A passthrough query is only EVER going to give you read-only data in MS Access mdb's and accdb's. There is nothing that you can do to change that. So, you are going to have to work around that limitation in the manner of your choice. One way is to create a local table to hold the data of the passthrough, and bind the form to THAT data. It will then be editable. You then have to create a mechanism to push the changes made to the local data back to its original source. That involves a fair bit of heavy lifting but is entirely doable. You get the speed and precision of the passthrough, but you lose the nice functionality of live editing and must code it. Or you go with ODBC linked tables, and Access linked tables that are ODBC-linked to indexed Views and gain the ability to live edit, but lose the speed and precision of a passthrough.

你也不能吃蛋糕.抱歉

这篇关于SQL Server后端，MS Access前端:连接的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！