|
Subject:
|
Write Conflict message
|
|
Posted By:
|
mmcdonal
|
Post Date:
|
11/17/2004 8:32:23 AM
|
Hi,
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.
Thanks,
mmcdonal
|
|
Reply By:
|
mmcdonal
|
Reply Date:
|
11/17/2004 10:39:37 AM
|
Also, if I open the tables with the Enterprise Manager, I can make changes to the records with no problem.
Would using an Access adp help?
mmcdonal
|
|
