ADO Write Conflict - Bound Access Form
Posted on 2004-10-25
Hi there everyone,
I ran into a problem and can't seem to find any help in EE on this issue.
I have an Access 2003 Database using a SQL Server 2000 backend. There are no tables or queries in the Frontend, only forms and code (using ADO to do everything)
There is a form that calls a stored proc when it opens. The stored procedure returns 3 recordsets and I populate two combo boxes with two of them and then bind the form (in continuous forms view) to the other recordset. The data displays perfectly and I can make a change (operative word being "a") to a record via the form. I added a save button that saves the current record using
Here in lies the problem. If I attempt to make another change to same record after clicking the save button, I get a write conflict error. I'm opening the recordset with these properties set.
.CursorLocation = adUseServer
.LockType = adLockOptimistic
.CursorType = adOpenDynamic
The recordset that is bound to the form does have an inner join to get some supporting information from another table.
Can someone shed some light on why I can't edit the same record twice? I don't want to go to SQL Server and get the recordset again unless I have to.