S
Sally Green
I have an Access 2000 format mdb running in Access 2003.
Database is split into front end and back end, running on
a network. Intermittent error 3197 occurs within a
subform on Update.
I've disabled all code, error stills occurs. Error
occurs even if running on stand alone pc. I read
somewhere about formatting all dates in tbls to
yyyy/mm/dd and setting Allow Zero properties in tbls to
No. This seemed to clear up the problem but it has
started again, but NOT AS FREQUENTLY!
Error 3197 - The Microsoft Jet Engine cancelled the
process because you and another user are trying to change
the same record at the same time.
Has anyone got a solution for me. I'm at my wits end!
Thanks
Sally
Database is split into front end and back end, running on
a network. Intermittent error 3197 occurs within a
subform on Update.
I've disabled all code, error stills occurs. Error
occurs even if running on stand alone pc. I read
somewhere about formatting all dates in tbls to
yyyy/mm/dd and setting Allow Zero properties in tbls to
No. This seemed to clear up the problem but it has
started again, but NOT AS FREQUENTLY!
Error 3197 - The Microsoft Jet Engine cancelled the
process because you and another user are trying to change
the same record at the same time.
Has anyone got a solution for me. I'm at my wits end!
Thanks
Sally