PRB: Jet 4.0 Row-Level Locking Is Not Available with DAO 3.60 (306435)
The information in this article applies to:
- Microsoft Data Access Components 2.1
- Microsoft Data Access Components 2.1 (GA)
- Microsoft Data Access Components 2.1 SP1
- Microsoft Data Access Components 2.1 SP2
- Microsoft Data Access Components 2.5
- Microsoft Data Access Components 2.5 SP1
- Microsoft Data Access Components 2.5 SP2
- Microsoft Visual Basic Enterprise Edition for Windows 6.0 SP4
- Microsoft Visual Basic Enterprise Edition for Windows 6.0 SP5
- Microsoft Access 2000
- Microsoft Access 2002
This article was previously published under Q306435 SYMPTOMS
According to Microsoft Knowledge Base article 275561 "ACC2000: New Features in Microsoft Jet 4.0":
To minimize the impact of the increased page size and respond to a long-standing request from developers building applications based on the Microsoft Jet database engine, row-level locking was added to Jet 4.0.
However, row-level locking of an Access database is not available with Data Access Objects (DAO) 3.60.
RESOLUTION
To resolve this problem, use ActiveX Data Objects (ADO) to enable row-level locking on an Access database, and then open DAO connections to the database. All subsequent attempts to open DAO connections to the database will respect the locking mode that you set.
STATUS
This behavior is by design. DAO 3.60 was not updated to incorporate this Microsoft Jet 4.0 functionality.
REFERENCES
For more information, see the following MSDN Web sites:
Modification Type: | Major | Last Reviewed: | 6/25/2004 |
---|
Keywords: | kbCodeSnippet kbDatabase kbJET kbMDACNoSweep kbprb KB306435 |
---|
|