By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
434,677 Members | 1,060 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 434,677 IT Pros & Developers. It's quick & easy.

Error 3197

P: n/a
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
Nov 13 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a
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.

Nov 13 '05 #2

P: n/a
"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
Nov 13 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.