[AccessD] Access 2007 Report Application ? SQL Server via ODBC ? Deadlock Issue

All,

We have a small Access 2007 reporting application that obtains data from SQL Server via ODBC.

This application updates no data.

Recently an ODBC error occurred because of a “Deadlock”

The “Record Locks” property for the query is set up “No Locks”

Is there a way to tell SQL Server to not set any locks for such an application.

Thanks,
Brad