ADO and SQL Server
Others' Changes Visible Property
The Others' Changes Visible property specifies whether row updates or deletions by a process other than the application accessing a recordset are visible without statement reexecution.
Applies To
| Command Object | Recordset Object |
Syntax
object.Properties("Others' Changes Visible") [= value]
Parts
object
Expression that evaluates to an object in the Applies To list.
value
Boolean that specifies whether updates or deletions by another process are visible, as described in Settings.
Settings
| Value | Description |
|---|---|
| True | Rows modified (updated or deleted) by an application or process other than the application accessing the recordset are visible. For example, if another process or application updates the data underlying a row or deletes the row, and the row is released completely, any application accessing the recordset will see that change the next time it fetches the row. This includes updates and deletes made by others in the same transaction as well as updates and deletes made by others outside the transaction.
The transaction isolation level does not affect the visibility of rows inserted by others in the same transaction, such as other recordsets in the same session. However, it does restrict the visibility of rows inserted by others outside the transaction. |
| False | Changes to the recordset (updates and deletes) made by other applications accessing the recordset are not visible unless the command is reexecuted. |
Data Type
adBoolean
Modifiable
Read/write
OLE DB Property
DBPROP_OTHERUPDATEDELETE