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.