Urgent!!! ADO Update conflict
I am trying to update a disconnected recordset back to the database. I am
getting update conflict as some other user has modified the information.
How to override the error and force an update?
I am using three different functions for connection, fetch and update. In
fetch i disconnect the recordset and pass back the recordset object to the
calling module. In the update, i reconnect and do an update batch. My update
code is as follows.
Set .ActiveConnection = mConn
'filters all the conflicting records and updates rest
.Filter = adFilterConflictingRecords
'update made by the current user will only succeed if no _
'changes have been made to any fields in that row in the table.
.Properties("Update Criteria").Value = adCriteriaAllCols
'Returns only modified rows to the server.Improve performance _
'when modified remote data is marshaled for updating
.MarshalOptions = adMarshalModifiedOnly
'Set ConflictRst = mRst
Set mRst.ActiveConnection = Nothing
Top DevX Stories
Easy Web Services with SQL Server 2005 HTTP Endpoints
JavaOne 2005: Java Platform Roadmap Focuses on Ease of Development, Sun Focuses on the "Free" in F.O.S.S.
Wed Yourself to UML with the Power of Associations
Microsoft to Add AJAX Capabilities to ASP.NET
IBM's Cloudscape Versus MySQL