Figured this one out...thanks for the tip on the trace log. When using the DAO library in Access to open a sql server recordset it forces you to use...

Hi, Here is a copy of my code. I'll ask our dba to run a trace on it to see if it is setting the switch to ON.

Dim dbNewDistrib...