Error 3197

[sbsmith]

Using Access 2002. After adding or changing data in an existing record and trying to go to another record I receive the error message 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. I am not in a multi user environment. Also, occassionaly receiving Error 3159, Bookmark. Is the data corrupted? If so, what is the best way to remedy? Thanks.

 

[Tony Toews]

Using Access 2002. After adding or changing data in an existing record and trying to go to another record I receive the error message 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. I am not in a multi user environment. Also, occassionaly receiving Error 3159, Bookmark. Is the data corrupted?

Yes.

For more information on corruption including possible causes,
determining the offending PC, retrieving your data, links, official MS
KB articles and a list of vendors who state they can fix corruption
see the Microsoft Access Corruption FAQ at
http://www.granite.ab.ca/access/corruptmdbs.htm
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm

 

[Markus Larsson]

Yes.

For more information on corruption including possible causes,
determining the offending PC, retrieving your data, links, official MS
KB articles and a list of vendors who state they can fix corruption
see the Microsoft Access Corruption FAQ at
http://www.granite.ab.ca/access/corruptmdbs.htm
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm

Are you sure that the data is corrupted, because my users get this error from time to time (Sometimes they can work for days without the error, next day it happens all the time.). I does a regular compact and repair on all my databases and check the data from time to time, and I can't se any corruption.

Markus

 

[Tony Toews]

Are you sure that the data is corrupted, because my users get this error from time to time (Sometimes they can work for days without the error, next day it happens all the time.). I does a regular compact and repair on all my databases and check the data from time to time, and I can't se any corruption.

No, not entirely. But when a stand alone user reports this problem
then that's my diagnosis.

For multiple users the problem is likely that the records are on the
same 2kb page for Jet 3.5 or 4kb page for Jet 4.0. Unless you are
using record locking Access uses page locking. Thus it's quite
possible for "collisions" to be occurring.

But I don't think we've figured out all of these issues either.

Hmm, are you users are all the same version of msjet?

Make sure you have the latest Jet 4 Service Pack installed.

To determine if you have the latest version of Jet installed you
search on msjet40.dll on your system. You should only find the one
in your WIndows\System 32 directory. When you right click on the
file >> Properties >> Version you can see the version number.

Jet 4.0 SP 6 - 4.0.6218.0
Jet 4.0 SP 8 - 4.0.8015.0
Microsoft Security Bulletin MS04-014 - 4.0.8618.0

For a somewhat complete list of msjet40.dll versions see
How To: Obtain the Latest Service Pack for the Microsoft Jet 4.0
Database Engine
http://support.microsoft.com/default.aspx?kbid=239114

If Windows XP ignore the msjet40.dll files found in the following
directories:
C:\WINDOWS\LastGood\System32
C:\WINDOWS\ServicePackFiles\i386

If Windows 2000 ignore the msjet40.dll files found in the following
directories:
C:\WINNT\ServicePackFiles\i386

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm

 

[Markus Larsson]

Make sure you have the latest Jet 4 Service Pack installed.
Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm

I have the latest Jet 4 version installed.

All my users are running Access 2000 on the same machine using Terminal Server and I have the databeses on the same machine so I have no network traffic.

This error occur in three different programs, but they all use a tempoary table for the subform, there are never much data in these tables, the data are moved to a real table after the user are finiched with the operation.

Can a newer Access version fix this problem?
Or do I need to use anathoer database as backend?