Error 3197 - Jet Database Engine

[Rothron]

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.

 

[gino]

i don't know how you set up your database but this happend about a month ago in my office. some users had different "frontend" versions then others. i built a code to force every user on the network to download the latest upgrade i've created. also, be aware of NTFS permissions. be sure the share permissions are correct. is your database on a server or a workstation?

 

[Melody]

I have a two forms. Form II is based on a query. One of the fields in this form includes a field that is also on my main form. (In the query for this form there is a string of criteria - [forms]![Site Information Form]![CustomerID]- underneath the CustomerID field that tells it to match this field up with the contents of the same field located on my main form.) Anyway - When I attempt to close Form II I get the message "The Microsoft Jet database engine cannot find a record in the table 'Customers Table' with key matching field(s) 'CustomerID'. Any ideas?