Error 3197

[Earl Anderson]

We have a small (15MB) application which we run over our office network with
4 client stations. Anytime we use the "Find" function (from the main form
which is based on a query of the main table) or run a query or try to
"Copy" - "Paste" in the database window on the main table of the
application, we get the following error message with the accompanying 'Help'
message:

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

HELP states, "This error can occur in a multiuser environment.
Another user has changed the data you are trying to update. This error
can occur when multiple users open a table or create a Recordset and use
optimistic locking. Between the time you used the Edit method and the
Update method, another user changed the same data.
To overwrite the other user's changes with your own, execute the Update
method again."

When using the "Find" function on a form, we can "OK" our way through the
error message and it "Finds" the value sought. On any other operation
involving the underlying table, clicking the "OK" does nothing except clear
the error message, leaving the user in the state prior to executing the
query or copy action.

The puzzler is that this occurs when all client machines are off except one,
so how can "Another user" be changing the data?

Does anyone know what the message really means (in our situation) and how to
fix it?

Thanks much for any help...
Earl Anderson

[Salad]

Earl Anderson wrote:

We have a small (15MB) application which we run over our office network with
4 client stations. Anytime we use the "Find" function (from the main form
which is based on a query of the main table) or run a query or try to
"Copy" - "Paste" in the database window on the main table of the
application, we get the following error message with the accompanying 'Help'
message:

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

HELP states, "This error can occur in a multiuser environment.
Another user has changed the data you are trying to update. This error
can occur when multiple users open a table or create a Recordset and use
optimistic locking. Between the time you used the Edit method and the
Update method, another user changed the same data.
To overwrite the other user's changes with your own, execute the Update
method again."

When using the "Find" function on a form, we can "OK" our way through the
error message and it "Finds" the value sought. On any other operation
involving the underlying table, clicking the "OK" does nothing except clear
the error message, leaving the user in the state prior to executing the
query or copy action.

The puzzler is that this occurs when all client machines are off except one,
so how can "Another user" be changing the data?

Does anyone know what the message really means (in our situation) and how to
fix it?

Thanks much for any help...
Earl Anderson

Do you have any code in the Before/After update events of the form that
update records via a recordset or update fields after you have saved
the record?

You have some code running someplace that is updating when you don't
think it is.

[Tony Toews]

"Earl Anderson" <is*****@rcn.com> wrote:

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

Help is wrong. <smile>

This is a symptom of a corrupt memo field.

See the Locating damage via code section at the following page.
A third method to locate minor corruption, especially in memo fields is to write some
code which loops through the records looking for an error when accessing the memo
field(s).
http://www.granite.ab.ca/access/corr...uptrecords.htm

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