This article was previously published under Q190753
This article has been archived. It is offered "as is" and will no longer be updated.
If you choose to delete a record on an Active Server Pages (ASP) page, whenthe record has been already deleted by another user, the page is notrefreshed to indicate that the record was already deleted.
You can work around this by checking for the return value of the deleteoperation. DeleteRecord() function returns false if the operation failed.If you want to see the new data, you need to catch the return code and do amove on the recordset.
Microsoft has confirmed that this is a bug in the Microsoft products that are listed at the beginning of this article.
This bug was corrected in Visual Studio 6.0 Service Pack 3. For more information about Visual Studio service packs, please see the following articles in the Microsoft Knowledge Base:
194022 INFO: Visual Studio 6.0 Service Packs, What, Where, Why
194295 HOWTO: Tell That Visual Studio 6.0 Service Packs Are Installed
Sample code to illustrate the work around mentioned above:
Sub Button1_onclick() if not Recordset1.deleteRecord() then Recordset1.move(0) end if End Sub