MS Access查询将返回不同的结果，具体取决于数据是本地数据还是网络数据 [英] MS Access Query returns different results depending on whether data local or on network

问题描述

在将Access的拆分数据库的表数据存储在网络驱动器上的情况下，Access表现不佳之前，我遇到了一些问题.我在一家大型科技公司工作，所以我希望所有的IT工作都做对.

I've run into problems before where Access behaved poorly with a split database where the table data was stored on a network drive. I work for a very large tech company, so I'm hoping all the IT stuff is done right.

我正在使用Access 2010，并且正在运行Windows 7企业版Service Pack 1.

I'm using Access 2010, and running Windows 7 enterprise, service pack 1.

今天是这里的问题:

如果我编写了一个非常简单的查询，要求输入合同ID，合同标题，合同编号等，则一切正常.我什至可以在摘要中添加备注类型的摘要，摘要可能为1000个字符左右.

If I write a very simple query that asks for contract ID's, Contract Titles, Contract numbers, etc.... it all works fine. I can even add in the Abstract, which is of memo type, and might be 1000 characters or so.

然后事情变得多毛的.根据我在查询中要求的内容，摘要要么起作用，要么变成单个汉字.其他一些备注字段也会发生相同的情况，其中某些备注字段少于100个字符.

Then things get hairy. Depending on what else I ask for in the query, the abstract either works, or gets changed into a single Chinese character. Same thing happens with a few other memo fields, some of which are under 100 characters.

如果我将数据库的后端部分复制到本地驱动器，重新链接表，并运行完全相同的查询，则它每次都像冠军.

If I copy the backend part of the database to my local drive, relink the tables, and run the exact same query, it works like a champ every single time.

似乎这是数据超时问题或类似问题.任何人对此都有任何经验或知道如何解决?这不是Web访问.之前的BTW问题是一个非常大的表更新查询-需要使后端本地化才能工作.

It seems as if this is a data timeout issue or something like that. Anybody have any experience with this or know how to fix it? This isn't Web Access. BTW issue before was with a very large table update query - needed to make the backend local for it to work.

我应该放弃并改用SQL Server吗?有已知的解决方法吗?

Should I just give up and change to SQL server? Are there known workarounds?

谢谢

格罗米特

推荐答案

这是Access-Jet错误.

This is an Access - Jet bug.

http://allenbrowne.com/bug-18.html

使用总计时，不能可靠地在备忘字段中使用分组依据.不知道为什么有时它有时在本地运行，而永远不会在整个网络上运行，这也许是一个计时性的事情.

When using totals, you can't use group by on the memo fields reliably. Not sure why it sometimes worked local and never across the network, maybe a timing thing.

解决方案是将备注字段设置为第一".

Solution is to set the memo fields to "first".

克里斯

这篇关于MS Access查询将返回不同的结果，具体取决于数据是本地数据还是网络数据的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！