Write Conflict message with SQL Server tables
I have a simple form based on a table that is linked to a SQL server back end.
The form is to a junction table where users are assigned assets. I use a look up combo box to select a serial number, then I use the tables combo boxes to change the user name etc. I have a button to close and reopen the same form to make sure the update has gone through.
This has been working fine for a few months, but now, most times when I click the update button (close, reopen) I get a Write Conflict dialog box that states that the record has been changed by another user since I opened it. I know no other user is connected to the database. Normally there is an option to Save Record, but it is greyed out.
Any help on this?
Look it up at: http://wrox.books24x7.com