Write Conflict?

[batowl]

Hi All,

I have a very perplexing problem with a newly created database. The database consists of many tables (29) that the user enters data into via a main form that has several subforms on it.



When the user enters the first piece of data on one specific table (that has been placed on the main form, let's call it Table B, it has a one-to-one relationship with the primary key), they get the following Write Conflict Error:

"The record has been changed by another user since you started editing it. If you save the record, you will overwrite the changes the other user made.

Copying the changes to the clipboard will let you look at the values the other user entered, and then paste you changes back in if you decide to make changes.

(Buttons that I can then click)
Save Record
Copy to Clipboard
Drop Changes"

At this point the primary key loses the value that the user entered into it and defaults to zero.

I have never run into this problem before and I cannot detect any difference between this table and any other tables within the database that do not cause this problem. Anyone run into this problem before and have a potential solution? Thank you.

[ranman256]

yes, you cannot have many cooks in the kitchen.
Did you split your database? Frontend (1 to each user) and the backend (1 single db of tables on a server)
If not this could be the problem.

[burrina]

Also, check Client Settings.Default Open Mode
Default Record Locks

[batowl]

Yes, the database is split. And I am only trying to enter data from the front end. And I am the only user at this time, so it is not a case of several users trying to alter the same record.

[batowl]

Ugh. The primary key field in the child table (the one that was causing problems) still had a default value of 0 assigned to it. That was the issue.