ADO使用问题

解决Microsoft Jet 数据库编辑冲突与内存泄漏

最新推荐文章于 2020-12-23 18:28:15 发布

Xxin_W

最新推荐文章于 2020-12-23 18:28:15 发布

阅读量862

点赞数

CC 4.0 BY-SA版权

分类专栏： windows

本文链接：https://blog.youkuaiyun.com/Xxin_W/article/details/49424665

windows 专栏收录该内容

9 篇文章

订阅专栏

本文档详细介绍了在使用Microsoft Jet数据库时可能遇到的问题，包括尝试在同一事务中更新已被编辑过的记录时出现的锁定错误，以及进行大量插入操作导致的应用程序内存消耗过高的情况。提供了微软官方的知识库链接来帮助理解这些问题的根本原因及解决方案。

BUG: "Could Not Update; Currently Locked" Error Message Raised by Second Edit Attempt in a Transaction

When you try to execute a SQL statement that changes a record of a table that was edited earlier in the same transaction, you may receive the following error message:

Run-time error '-2147467259 (80004005)':
Could not update; currently locked.

微软解释 https://support.microsoft.com/en-gb/kb/331594

PRB: Jet OLE DB Provider Consuming Too Much Memory

After performing a large number of operations ( for example, inserts) on a Microsoft Jet database engine with the Jet 4.0 OLE DB Provider, large amounts of memory are consumed by the application. For example, performing 1000 inserts in a tight loop may reveal 100+ megabyte usage. When the connection is closed, the memory is freed

微软解释 https://support.microsoft.com/en-gb/kb/248014

FIX:A memory leak may occur when you use the Microsoft ActiveX Data Objects Library in Windows Vista, in Windows 7, in Windows Server 2008, or in Windows Server 2008 R2

微软解释 https://support.microsoft.com/en-gb/kb/978042