访问“没有足够的内存” - 错误3183 [英] Access "not enough memory" - error 3183
问题描述
嗨伙计，
头疼得厉害。我是SAM公司项目的承包商，他们使用Access数据库，通过特定查询将extrat信息从DB导入Visio。
查询是非常冗长的，并且需要很长时间来删除公司特定的信息，所以我会保持这个简短。
当我的机器上本地使用时，查询在数据库上正常运行（Acer Aspire 5003WLMi ，1.8GHz AMD Turion ML-32处理器，512MB RAM，60GB HDD和WinXP SP2）但在公司的机器上使用时（HP DX2250,512MB RAM，160GB HDD和AMD Athlon 64-bit 3800+ - 约2.0） GHz）Jet 4.0引擎（因为数据库使用链接表）创建一个达到2GB的TMP文件，然后出现临时磁盘上没有足够内存的错误。
我查了一下：
- 临时文件夹权限和大小限制;
- Microsoft的知识库和推荐的修复程序（列在 http://support.microsoft.com/kb/286153/en-us);
- 检查所有修补程序，Service Pack和ODBC / Jet驱动程序;
如果有人对如何解决这个问题有任何想法，那就非常感激。
非常感谢提前，
medicineworker
您是否检查过Office所在的位置文件？
我在D：驱动器上运行我的.mdb时运行一次，但C：驱动器上的空间不足（小于150Mb）我收到了这个错误....
Nic; o）
嗨nico，
检查过，MDB在C：驱动器上运行和temp位于C：\Documents and Settings \％登录用户％\ Local Settings \Temp。
我检查了读/写权限，一切都很好。
我知道Access不会处理任何大于2GB的数据。正在创建的TMP文件一直到2GB，这表明（我认为）Jet ODBC驱动程序正在泄漏某些东西（因为查询在我的机器上运行时没有问题）。
我在机器之间注意到的唯一重要区别是：我安装了SQL Server 2005 Express，同事们建议可能修复（可能已损坏）驱动程序，我也有Jet 3.0和3.5以及4.0（惠普机器只有Jet 4.0，没有以前的版本）。它可能与向后兼容性有关（所有使用链接表的Access数据库都是Access 2000格式）？
非常感谢提前，
medicineworker
Addenum - 已将数据库转换为Access 2003格式，但仍然没有运气，在70 - 100％的范围内获得CPU峰值。我的经理说我们的电脑仍应保修...... lmao。
任何最后一分钟的建议都会受到赞赏。
medicineworker
Hi folks,
Got a massive headache. I''m working as a contractor on a project for a SAM company and they are using an Access database with a particular query to extrat information to import from a DB into Visio.
The query is incredibly lengthy and would take too long to remove company-specific info from so I will keep this brief.
The query runs fine on the database when it is used locally on my machine (Acer Aspire 5003WLMi, 1.8GHz AMD Turion ML-32 processor, 512MB RAM, 60GB HDD and WinXP SP2) but when used on the company''s machines (HP DX2250, 512MB RAM, 160GB HDD, and AMD Athlon 64-bit 3800+ - around 2.0GHz) the Jet 4.0 engine (as the DB uses linked tables) creates a TMP file that hits 2GB before coming up with an error of "not enough memory on temporary disk".
I have checked:
- Temporary folder permissions and size limits;
- Microsoft''s knowledge base and recommended fixes (listed at http://support.microsoft.com/kb/286153/en-us);
- Checked for all patches, service packs and ODBC/Jet drivers;
If anyone has any ideas on how to fix this then it would be so much appreciated.
Many thanks in advance,
medicineworker
Did you check where Office has located the temporary files?
I ran once in trouble running my .mdb on a D: drive, but being low on space on the C: drive (less then 150Mb) I got this error....
Nic;o)
Hi nico,
Have checked, MDB is running on C: drive and temp is located in C:\Documents and Settings\%Logged on User%\Local Settings\Temp.
I have checked read/write perms and all is fine there.
I understand that Access will not deal in any data that is larger than 2GB. The TMP file that is being created goes all the way up to 2GB which suggests (I think) that the Jet ODBC driver is leaking something (as the query runs absolutely fine on my machine with no problems).
The only substantial difference I have noticed between the machines is this: I have SQL Server 2005 Express installed, which colleagues have suggested might fix the (probably broken) drivers, and I also have Jet 3.0 and 3.5 as well as 4.0 (the HP machines only have Jet 4.0 and no previous versions). Could it be something to do with backward-compatibility (all Access DBs that use linked tables are in Access 2000 format)?
Many thanks in advance,
medicineworker
Addenum - have converted databases to Access 2003 format and still no luck, getting CPU spikes in the region of 70 - 100%. My manager says our PCs should still be under warranty... lmao.
Any last-minute suggestions would be appreciated.
medicineworker
这篇关于访问“没有足够的内存” - 错误3183的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
