I keep getting the Microsoft Jet Database Engine stopping use of the database with Error 3197 - saying that "you and another user are attempting to change the same data at the same time". I have no record locks on and as there are only 6 of us in the office (not all of whom use the d/base) we know what records each other is in - therefore this error is confusing. This error occurs when searching for a record, when amending a record, when calling up a report - in fact all over the place.
The Default Open Mode settings are set to Shared because, as I understand it, if it is set to exclusive only one person can be in the d/base at the same time.
If anyone has any suggestions or comments I would be extremely grateful.
The Default Open Mode settings are set to Shared because, as I understand it, if it is set to exclusive only one person can be in the d/base at the same time.
If anyone has any suggestions or comments I would be extremely grateful.