I have a Remote view (ODBC Connection) calling an ACCESS table and I am doing a SCAN on it in order to delete some records (based on a condition) and I am getting the error message : " Connection MY_CONNECTION is busy "

MS has a knowlewdge base article on this problem: Q191343, PRB: Connection Busy Error with a Shared Connection. http://support.microsoft.com/support/kb/articles/Q191/3/43.ASP

The best solution I have found (for my situation) is to set the FETCHSIZE to -1 (All records).

Hope this helps,

Kevin