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

Jim Lawrence accessd at shaw.ca
Tue Jul 10 20:41:46 CDT 2012


Don't you do that when you call the recordsets; static and forward-only?

Jim

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Brad Marks
Sent: Tuesday, July 10, 2012 5:02 PM
To: Access Developers discussion and problem solving
Subject: [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      





More information about the AccessD mailing list