Article ID: 281887 - View products that this article applies to.
This article was previously published under Q281887
If you use a DataGrid to add a record to a server-side ActiveX Data Objects (ADO) recordset, you receive one of the following error messages when there are more records than the DataGrid can display:
c0000005 (access violation)
The Invalid Bookmark error message appears if Visual Studio Service Pack 5 (SP5) has not been applied. The access violation error message appears if you have Microsoft Data Access Components (MDAC) 2.6 or MDAC 2.7 installed (without any service pack) on a computer that has Visual Studio Service Pack 5 (SP5) installed.
To resolve this problem, obtain the latest service pack for Microsoft Data Access Components (MDAC ) 2.6 or MDAC 2.7. For additional information, click the following article number to view the article in the Microsoft Knowledge Base:
300635The easiest resolution is to switch to client-side cursors for instances where DataGrids are used to add records to ADO recordsets.
(https://support.microsoft.com/kb/300635/EN-US/ )INFO: How to Obtain the Latest MDAC 2.6 Service Pack
MDACThis problem was first corrected in MDAC 2.6 Service Pack 1, and MDAC 2.7 Service Pack 1.
Visual Studio 6.0This bug was corrected in Microsoft Visual Studio 6.0 Service Pack 5 (SP5). For additional information about Visual Studio service packs, click the following article numbers to view the articles in the Microsoft Knowledge Base:
194022To download the latest Visual Studio service pack, visit the following Microsoft Web site:
(https://support.microsoft.com/kb/194022/EN-US/ )INFO: Visual Studio 6.0 Service Packs, What, Where, Why
(https://support.microsoft.com/kb/194295/EN-US/ )HOWTO: Tell That a Visual Studio Service Pack Is Installed
Steps to Reproduce the Behavior
To revert back to an earlier version of MDAC, use the Component Checker Tool that you can download from the following Microsoft Web site:
Component Checker Tool
Article ID: 281887 - Last Review: August 7, 2007 - Revision: 7.3