Transaction Cannot Start in Firehose Mode - SQL Server

Today when trying to edit a record in the SQL Server Enterprise Manager, in the table view (right-click-> return all records), I got this error message: "Transaction Cannot Start in Firehose Mode" .

According to the Microsoft Knowledgebase : "When you right-click a table, and then click Return all rows, a firehose cursor is opened and only the rows that have been processed are displayed. After the failover occurs and after you reconnect to the virtual server, only a batch of the rows in the table are processed. The error message shown in the "Symptoms" section occurs when an OLE-DB provider attempts to perform a join transaction, with results pending, while not in an updateable cursor mode."

So basically I had to use the query analyzer to update this table. This is another reason why I prefer to work on data in SQL Servers using an MS Access frontend.