Hi Folks,
I have a form on a Access 2000 database that is linked to a SQL Server 7.0 table. Everything works just fine and about 300,000 records already exist in the database.
If I do a search on the form via a Query by Form, the query does return the results I want. However, when I try to update the data on the form and Save the Record, the following error is generated by Access?
Write Conflict
This 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 your changes back in if you decide to make changes.
<Below are the options>
Save Record (if is grayed out) Copy to Clipboard Drop Changes
If someone can explain to me how I can save a record that I edit via a Query by Form, I would GREATLY appreciate it. I have never seen an error like this before; and am not sure why there would be a write conflict as no other users have access to this database or is in the table being edited and I am the only one who even has it opened?
Thank you,
Joe
I have a form on a Access 2000 database that is linked to a SQL Server 7.0 table. Everything works just fine and about 300,000 records already exist in the database.
If I do a search on the form via a Query by Form, the query does return the results I want. However, when I try to update the data on the form and Save the Record, the following error is generated by Access?
Write Conflict
This 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 your changes back in if you decide to make changes.
<Below are the options>
Save Record (if is grayed out) Copy to Clipboard Drop Changes
If someone can explain to me how I can save a record that I edit via a Query by Form, I would GREATLY appreciate it. I have never seen an error like this before; and am not sure why there would be a write conflict as no other users have access to this database or is in the table being edited and I am the only one who even has it opened?
Thank you,
Joe
