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-Archive recommends: Fix windows errors by optimizing your registry

From: Kevin3NF (KHill_at_NopeIDontNeedNoSPAM3NF-inc.com)
Date: 04/29/04


Date: Thu, 29 Apr 2004 12:16:34 -0500

http://support.microsoft.com/default.aspx?scid=kb;en-us;318882&Product=acc

-- 
Kevin Hill
President
3NF Consulting
www.3nf-inc.com/NewsGroups.htm
www.DallasDBAs.com/forum - new DB forum for Dallas/Ft. Worth area DBAs.
"Kevin3NF" <KHill@NopeIDontNeedNoSPAM3NF-inc.com> wrote in message
news:%23tAkQagLEHA.1644@TK2MSFTNGP09.phx.gbl...
> Are there any bit fields in teh destination table that do not have a
default
> value set?
>
> -- 
> Kevin Hill
> President
> 3NF Consulting
>
> www.3nf-inc.com/NewsGroups.htm
> www.DallasDBAs.com/forum - new DB forum for Dallas/Ft. Worth area DBAs.
>
> "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

  • Re: Alter column to change IDENTITY Seed
    ... 3NF Consulting ... www.DallasDBAs.com/forum - new DB forum for Dallas/Ft. ... Worth area DBAs. ...
    (microsoft.public.sqlserver.programming)
  • Re: Scan and save type software
    ... 3NF Consulting ... www.DallasDBAs.com/forum - new DB forum for Dallas/Ft. ... Worth area DBAs. ...
    (microsoft.public.backoffice.smallbiz2000)
  • Re: Scan and save type software
    ... 3NF Consulting ... www.DallasDBAs.com/forum - new DB forum for Dallas/Ft. ... Worth area DBAs. ...
    (microsoft.public.backoffice.smallbiz2000)
  • Re: Database System
    ... 3NF Consulting ... www.DallasDBAs.com/forum - new DB forum for Dallas/Ft. ... Worth area DBAs. ...
    (microsoft.public.access.tablesdbdesign)
  • Re: Server Service not start
    ... 3NF Consulting ... www.DallasDBAs.com/forum - new DB forum for Dallas/Ft. ... Worth area DBAs. ...
    (microsoft.public.sqlserver.connect)