3035 - Windows 2000中超出了系统资源 [英] 3035 - System resource exceeded in Windows 2000

问题描述

我得到的是3035 - 超出系统资源运行DoCmd.TransferText以在Windows 2000上使用Access 2003将.csv文件加载到SQL链接表时出现错误消息.csv文件包含34804行，宽30列（19,086 KB）。

我已将MaxLocksPerFile的注册表设置更改为1,500,000，但这没有帮助。我在剧本中看到了另外一个关于此问题的讨论，但提问者似乎在谈论Windows XP，并没有完全回答他/她自己的讨论。


我需要做什么才能解决这个问题？

I am getting a "3035 - System resource exceeded" error message when running a DoCmd.TransferText to load a .csv file into a SQL linked table using Access 2003 on Windows 2000. The .csv file contains 34804 rows and is 30 columns wide (19,086 KB).

I have changed the registry setting of MaxLocksPerFile to 1,500,000 but this does not help. I have seen another discussion in thescripts concerning this but the questioner appears to be talking about Windows XP and does not completely answers his/her own discussion.

What do I need to do to resolve this problem?

推荐答案

我不知道我们在这里有多大帮助我很害怕。

我有一件事'建议首先尝试使用更小的.CSV文件。这将告诉您问题是否与资源相关，或者它是否是SQL Server的问题（权限或其他内容）。

我的下一个建议是尝试将其导入到本地访问表（尽管数据太多，但至少适合的数据）。这可能会突出显示数据本身的问题，这通常会导致来自Access的钝错误消息。

I''m not sure how helpful we can be here I''m afraid.
One thing I''d suggest to do first is to try it with a very much smaller .CSV file. This will tell you if the problem is resource related at all, or whether it''s an issue with SQL Server (permissions or something).
My next suggestion would be to try to import it into a local Access table (as much of the data as will fit at least if it''s too large). This may highlight a problem within the data itself which can often result in obtuse error messages from Access.

我不知道如何很有帮助我们可以在这里我很害怕。

我建议先做的一件事就是用一个非常小的.CSV文件来尝试它。这将告诉您问题是否与资源相关，或者它是否是SQL Server的问题（权限或其他内容）。

我的下一个建议是尝试将其导入到本地访问表（尽管数据太多，但至少适合的数据）。这可能突出显示数据本身内的问题，这通常会导致来自Access的钝错误消息。

I''m not sure how helpful we can be here I''m afraid.
One thing I''d suggest to do first is to try it with a very much smaller .CSV file. This will tell you if the problem is resource related at all, or whether it''s an issue with SQL Server (permissions or something).
My next suggestion would be to try to import it into a local Access table (as much of the data as will fit at least if it''s too large). This may highlight a problem within the data itself which can often result in obtuse error messages from Access.

我将导入限制为300行，10,000行和20,000行，并获得成功结果。在25,000行时，它因3035错误消息而失败。 PC上的内存使用率没有受到影响，也没有看到任何其他内容。


有没有人有建议？

I limited my import to 300 rows, 10,000 rows, and 20,000 rows with successful results. At 25,000 rows it failed with the 3035 error message. Memory usage on the PC was not affected, nor was anything else I looked at.

Does anyone have a suggestion?

所以它''这不是一个简单的SQL Server权限问题。

我的第二个建议怎么样？你在哪里得到的？

So it''s not a simple SQL Server permissionning issue.
What about my second suggestion? Where did you get with that?

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