In ODBC, updates and deletes that require cursor positioning can normally be performed by executing a positioned UPDATE or DELETE SQL statement (with the WHERE CURRENT OF clause), or by calling the SQLSetPos function with an fOption argument of SQL_POS_UPDATE or SQL_POS_DELETE. The Desktop Database Drivers do not support positioned UPDATE or DELETE SQL statements. They do, however, support the SQLSetPos function.
In addition to SQL_POS_UPDATE and SQL_POS_DELETE, SQLSetPos can also be called with the SQL_POS_ADD, SQL_POS_POSITION, and SQL_POS_REFRESH fOption arguments. The Microsoft Excel and Text drivers support only SQL_POS_POSITION and SQL_POS_REFRESH, because the files are read-only.