Write Conflict message
I have an Access database that uses linked SQL server tables. I have a form that allows me to reassign assets from one user to another by looking up the asset's serial number, and then changing the user's name. The form is based on a table, and after I make these changes I click a button to reload the form, which makes sure the table is updated.
This has worked fine for months, but recently I am getting a Write Conflict dialog box that says someone has changed the record since I started editing it, and if I save the changes, I will overwrite the record. This wouldn't be so bad, except the button to Save Changes is always greyed out, so I have to click Drop Changes.
I know no other users are making changes while I am. The only other users are data from a script that reports DMI information to other tables as users log in to the network.
Any help would be greatly appreciated.
Look it up at: http://wrox.books24x7.com