Re: Error 3197: The Microsoft Jet database engine stopped the process because you and another user are attempting to change the same data at the same time.

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: Chris Barber (chris_at_blue-canoe.co.uk.NOSPAM)
Date: 04/29/04 

Date: Thu, 29 Apr 2004 17:31:48 +0100

Look at cursor locations, locking methods and transactions. Transactions would help so that you can
detect the error, rollback, wait a short while and then try again. I'm not sure if you can ask it to
raise an event when a blocking process completes.

In SQL Server you can run a trace to determine which users / client apps are attempting the
conflicting updates. You may also be able to see this using sp_who executed from the Query Analyzer.

Chris.

"Brijesh Shah" <shah_brijesh@hotmail.com> wrote in message
news:uPW0KKgLEHA.1484@tk2msftngp13.phx.gbl...
Hi,

The Microsoft Jet database engine stopped the process because you and
another user are attempting to change the same data at the same time. (3197)

We are getting this error while inserting/updating SQL Server database using
the Jet engine. Jet 3.6, SQL Server 2000. Any ideas?

Thanks,

Brij

Relevant Pages