问题描述
您好，我们已将MS Access连接为SQL Server的前端。  我的一个用户遇到Access挂起，需要在表单上的Combox框中选择一个值时重新启动。 这似乎对他来说发生了很大的影响，但它间歇性的是b
。当我在自己的机器上测试它时，我也遇到了同样的错误，但它又是断断续续的。  我的困境是逻辑上，如果Combox框和选择值的能力在大多数时间工作，那么实际的组合框和表格
配置是可以的。 如果它不能间歇性地工作，那么这只是暂时失去与SQL Server连接的情况吗？或者我需要检查其他任何内容吗？
Hi, we have MS Access connected as a frontend to SQL Server. One of my users is experiencing Access hanging and needing to be restarted when he picks a value in a Combox box on a form. This seems to be happening for him a far bit but it is quite intermittent. I also experienced the same fault when I tested it on my own machine but again it is intermittent. My dilemma is that logically if the Combox box and the ability to select a value works most of the time then the actual combo box and form configuration is ok. If it doesn't work intermittently then is this simply a case of a momentary loss of connection to SQL Server? OR do I need to check anything else??
提前感谢任何想法/建议。
Thanks in advance for any thoughts/advice.
Dan
推荐答案
另外，你如何从数据库中填充CombBox？它可能只是因为你试图加载太多数据而变慢。
Also, how are you populating the CombBox from the database? It could be that it's just slow because you're attempting to load too much data.
这篇关于单个用户访问SQL Server连接..和我，但间歇性。的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持！