I am using Windows Authentication in SQL registration properties. I open Query Analyzer from inside EM, and so the connection is already there, using Windows Authentication again, I assume.

I believe that MS Access also uses ODBC, and that is where I first saw the problem. I am unfamiliar with 'osql'.

The front end for this DB is currently MS Access. The work-around is to have a REFRESH button in Access. This fixes the data error, but is not very desirable in a new DB.