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.
Run-time error '-2147467259 (80004005)':
Could not update; currently locked.
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
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