系统资源除外 [英] system resource exceded

问题描述

展开 | 选择 | Wrap | 行号

推荐答案

您是在循环中调用此函数吗？你是什​​么意思独特的序列？你想要一个随机数吗？每次运行时，结果序列将增加至少110万。这就是你想要的吗？


Jim

Are you calling this function from within a loop? What do you mean by "unique sequence?" Are you trying to get a random number? Your resulting sequence is going to be increasing by at least 1.1 million every time you run this. Is that what you want?

Jim

150万个档案锁......为什么？

DAO.DBEngine.SetOption dbMaxLocksPerFile，1500000

您应该只调用此选项ONCE，最好是在主代码模块中，而不是每次执行该函数时都是应该在主代码中释放这些资源。


此外，还有与该错误文本关联的错误NUMBER。请发布错误的数字和文字。许多错误共享相同或相似的文本，因此数字也是必需的。

1.5 million file locks... why?

DAO.DBEngine.SetOption dbMaxLocksPerFile, 1500000
You should only call this option ONCE, preferably in the main code module, not every time you execute the function and you should release these resources in the main code.

Also, there is an error NUMBER associated with that error text. Please post BOTH number and text for errors. Many of the errors share the same or similuar text so the number is also required.

可能使用变量存储CurrentDb而不是调用它三次也会有所帮助。

Possibly using a variable to store the CurrentDb instead of calling it three times would also help.

展开 | 选择 | Wrap | 行号

这篇关于系统资源除外的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！