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

__________________
mmcdonal

Look it up at: http://wrox.books24x7.com

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