I am getting the error 3197: "You and another user are attempting to change
the same data at the same time." when I try to use the recordset.edit
method.

There is one user running the application.

I do NOT get the error if I start the application from scratch and procede
directly to the form which is causing the problem.

I do get the error if I first try to run a few tasks then run the form which
is causing the problem.

I have tried to locate any problems in my code such as opening recordsets
and not closing them. But so far I have not found any. (doesn't mean that
they don't exist, though)

Has anyone had a prior experience with this error and how was it resolved?

Thanks ahead of time,

David Howlett
Amulet Consulting

Do you have a bound form open on the same record you are trying to edit with
DAO?

Alden

Alden,

Yes.

I use recordsetclone to create the recordset object, then when I attempt the
edit method I get the 3197 error.

However, as I mentioned, it works sometimes and does not work other times. I
seem to get the error when I try to run other parts of the application
first.

David Howlett

Hi Dave,

You need the Jet update for Access 97.  Try installing this file

http://support.microsoft.com/download/support/mslfiles/JET35UPD.EXE

HTH

--
Dev Ashish (Just my $.001)
---------------
The Access Web ( http://home.att.net/~dashish )
---------------

:Alden,
:
:Yes.
:
:I use recordsetclone to create the recordset object, then when I attempt
the
:edit method I get the 3197 error.
:
:However, as I mentioned, it works sometimes and does not work other times.
I
:seem to get the error when I try to run other parts of the application
:first.
:
:David Howlett
:
:
:>Do you have a bound form open on the same record you are trying to edit
:with
:>DAO?
:>
:>Alden
:>
:> ===============================================
:>>
:>>
:>>I am getting the error 3197: "You and another user are attempting to
:change
:>>the same data at the same time." when I try to use the recordset.edit
:>>method.
:>>
:>>There is one user running the application.
:>>
:
:>>I have tried to locate any problems in my code such as opening recordsets
:>>and not closing them. But so far I have not found any. (doesn't mean that
:>>they don't exist, though)
:>>
:>>Has anyone had a prior experience with this error and how was it
resolved?
:>>
:>>Thanks ahead of time,
:>>
:>>David Howlett
:>>Amulet Consulting
: