增加VB中打开的dao记录集的数量？
我在 VB 应用程序中打开了一个 dao 记录集。问题是我收到“3037”运行时错误，该错误表明我无法打开更多表或查询。所以，我必须关闭一些，但这似乎不起作用...有什么方法可以增加打开的记录集的数量吗？
当我单击某一列时，我使用下一个代码对 FlexGrid 表进行排序，
...
recordSet.Sort = recordSet.Fields(2).Name & " ASC"
Set Auxrecordset = recordSet.OpenRecordset
recordSet.Close
Set recordSet = Auxrecordset
...
谢谢。
编辑：
此错误是否会影响此？
I've opened a dao recordset at a VB application. The problem is that I received an '3037' runtime error, this error says that I can't open any more tables or queries. So, I have to close some, but this doesn't seem to work... Is there any way to increase the number of opened recordsets?
I use the next code to sort a FlexGrid table when I click on a column,
...
recordSet.Sort = recordSet.Fields(2).Name & " ASC"
Set Auxrecordset = recordSet.OpenRecordset
recordSet.Close
Set recordSet = Auxrecordset
...
Thanks.
EDIT:
Does this bug affect this?
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（2）
与其重新发送查询只是为了对数据进行排序，为什么不这样做： http://www.vb-helper.com/howto_sort_flexgrid.html 来对网格中屏幕上的数据进行排序？
instead of re-sending the query just to sort the data, why don't you do something like this: http://www.vb-helper.com/howto_sort_flexgrid.html to sort the data on the screen in the grid instead?
您是否看过这篇知识库文章
http://support.microsoft.com/kb/165272
看起来像可能有适用的修补程序，但您可能已经拥有它。或者，是否有可能您正在打开记录集，但没有以某种方式关闭它们，而没有意识到这一点（可能是因为抛出了错误并且您没有到达关闭语句？）
Have you seen this kb article
http://support.microsoft.com/kb/165272
Looks like there might be a hotfix that's applicable, but you may already have it. Alternately, is it possible you're opening recordsets but not closing them somehow without realizing it (maybe because an error is being thrown and you're not reaching the close statement?)