MS Access 2003 - 导入数据时超出系统资源的消息 [英] MS Access 2003 - System Resources Exceeded Message When Importing Data
问题描述
我是这个网站的新手。我搜索并发现了类似的帖子，但不认为他们正在回答我的问题。
我有一个基本而简单的数据库。 4,170,000条记录，每条记录为6个字段。文件大小为1 Gb。
每月我有我们的I / T人员提供txt文件。然后我使用Import Spec并将数据导入到我的表中。在过去的4个月中，我遇到了一个问题，在我确定导入规范并进行导入后，我从导入文本向导对话框中收到了令人讨厌的消息 - 超出了系统资源。然后，我收到一条消息，指出发生了错误，并且未导入文件。如果我不使用Import Spec，我也会收到此消息，但只需手动导入 - 每次重新尝试导入时重命名字段。除了上面的消息之外，永远不会有任何错误信息。
令人恼火的是，直到几个月前我才能做到这一点。此外，当我有我们的I / T人员帮助时，她可以使用相同的方法在她的计算机上工作。此外，我可以在家里的桌面上使用它。所有这些让我相信Windows或其他系统都有一个设置阻止它工作。
其他事实 - 当Access是唯一的时候我收到此错误软件运行。我们增加了更多的内存，我相信它现在大约是1.5 Gb。
应用程序名称Microsoft Access
版本11.0
Build 5614
语言英语（美国）
VBA版本6.04
我添加了一些软件，但没有DB相关。我没有办法及时回过头来了解这个问题之前的设置。
任何想法从哪里开始我的搜索或我可以归零的东西检查???????
感谢任何人都能提供的帮助。
戴夫
I am new to this site. I have searched and found similar posts but don''t think they are answering my question.
I have a basic and simple DB. 4,170,000 records each record being 6 fields. File size is 1 Gb.
Monthly I have our I/T person provide me a txt file. I then use an Import Spec and import the data into my table. Over the last 4 months, I have run into a problem where after I OK the Import Spec and go to make the import, I get the nasty message from the Import Text Wizard dialog box -- "System resource exceeded." I then get a message that says an error occured and the file was not imported. I also get this message if I don''t use the Import Spec but just make the import manually - renaming the fields every time I reattempt the import. There is never any more error info other than the message above.
What is aggravating is that until a few months ago I could make this work. Also when I have our I/T person help, she can make it work on her computer using the same methodology. Also, I can make it work on my desktop at home. All of this leads me to believe there is a setting for either Windows or some other system that is preventing this from working.
Other facts -- I get this error when Access is the only software running. We added more memory, I believe it is now approx 1.5 Gb.
Application name Microsoft Access
Version 11.0
Build 5614
Language English (United States)
VBA version 6.04
I have added some software but nothing DB related. I don''t have a way of going back in time to know what the settings were prior to this problem.
Any ideas where to start my search or what I can zero in on to check???????
Thanks for any help anyone can provide.
Dave
推荐答案
这是一个措辞得很好的问题，我很抱歉，我无法提供任何帮助:(
我希望所有问题都明确说明 - 我们都有更多的时间来帮忙。
我能说的唯一可能有用的东西是：
1.访问很有名用于报告完全虚假的错误消息。不要依赖于报告的消息，指出错误实际是什么。
2.要解决问题，您可能需要设置一个单独的数据库，只是那张桌子。这可以从你的前端链接到你。你可能想要在使用后执行''Compact& Repair on it t。
这是一些启用压缩位的代码：
It''s such a well worded question that I''m sorry I can''t be any help :(
I wish all problems were stated as clearly - we''d all have so much more time to help with.
The only things I can say that may be of any use are :
1. Access is famous for reporting completely spurious error messages. Don''t rely on the message as reported indicating what the error actually is.
2. To get around the problem you may want to set up a separate database which has just that table in it. This could then be linked to from your front end. You would probably want to execute a ''Compact & Repair on it after using it.
Here is some code to enable the compacting bit :
你说你增加了更多的记忆。我认为这是RAM，因为这是我的第一个猜测。我的下一个猜测是，您访问安装时出错，并且您没有使用最新的Jet引擎。我的建议是卸载您的访问软件，然后重新安装。但是，您的IT人员可以在不执行此操作的情况下升级Jet引擎。
Mary
BTW，您没有说您使用的是什么版本的Access。
You say you added more memory. I assume this was RAM as that would have been my first guess. My next guess would be that there is an error in you access installation and you are not using an up-to-date Jet Engine. My suggestion here would be to uninstall your access software and then reinstall it. However, your IT person may be able to upgrade the Jet Engine without doing this.
Mary
BTW, you didn''t say what version of Access you were using.
您说您添加了更多内存。我认为这是RAM，因为这是我的第一个猜测。我的下一个猜测是，您访问安装时出错，并且您没有使用最新的Jet引擎。我的建议是卸载您的访问软件，然后重新安装。但是，您的IT人员可以在不执行此操作的情况下升级Jet引擎。
Mary
BTW，您没有说你正在使用什么版本的Access。
You say you added more memory. I assume this was RAM as that would have been my first guess. My next guess would be that there is an error in you access installation and you are not using an up-to-date Jet Engine. My suggestion here would be to uninstall your access software and then reinstall it. However, your IT person may be able to upgrade the Jet Engine without doing this.
Mary
BTW, you didn''t say what version of Access you were using.
Mary，
是的，我们添加了RAM。
Access 2003版本11.我从Access帮助中复制了详细信息，以便每个人都能看到。还有什么我想念的东西会有所帮助吗？
我会在看到我们是否可以先升级Jet引擎后尝试卸载。我的猜测是他们不知道怎么做，我也不知道，所以我们默认完全重新安装。
Dave。
Mary,
Yes, we added RAM.
Access 2003 Version 11. I copied the details off of the Access ''Help'' so everyone could see. Is there something else I am missing that would help?
I will try the uninstall after seeing if we can first upgrade the Jet engine. My guess is they won''t know how to do this, nor do I, so we will default to a complete re-install.
Dave.
这篇关于MS Access 2003 - 导入数据时超出系统资源的消息的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
