Form Error Msg on open

[jabrony76]

Hi all,
I've got a multiuser db on a network and when attempting to open a specific form the following msg shows:

"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)"

I read the help file and still don't know whats going on. Can someone interpret the help file? I don't know how to "execute the Update method again"

I'm attaching what it says below:

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.

Thanks for any help!
Andy

 

[scs2rescue]

I'm having the same problem while exporting a table to any other external file (Excel, text, DBIV, etc). Did you get any resolution on this?

I researched Microsoft KB and they suggested applying SP1 then SP2 of Access 97. Then downloading the newest Jet Database engine. The problem was still there. I did further investigation in MS KB and found that large comment fields often cause this problem. They suggest performing a COMPACT in Access which resulted in a NO CURRENT RECORD error message.

I do believe it's the comment field causing the problem because when I exclude that field from the export it works fine.

Please help. Client is about to "scrub" this project and I already have numerous hours in research & frustration.

Regards,

 

[annsolomon]

Is your database split? Putting the front end on the users' desktops might reduce the frequency of conflicts.