Wrox Programmer Forums
| Search | Today's Posts | Mark Forums Read
SQL Server 2000 General discussion of Microsoft SQL Server -- for topics that don't fit in one of the more specific SQL Server forums. version 2000 only. There's a new forum for SQL Server 2005.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the SQL Server 2000 section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
  #1 (permalink)  
Old November 17th, 2004, 09:32 AM
Friend of Wrox
Points: 9,611, Level: 42
Points: 9,611, Level: 42 Points: 9,611, Level: 42 Points: 9,611, Level: 42
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Mar 2004
Location: Washington, DC, USA.
Posts: 3,069
Thanks: 0
Thanked 10 Times in 10 Posts
Default Write Conflict message

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
  #2 (permalink)  
Old November 17th, 2004, 11:39 AM
Friend of Wrox
Points: 9,611, Level: 42
Points: 9,611, Level: 42 Points: 9,611, Level: 42 Points: 9,611, Level: 42
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Mar 2004
Location: Washington, DC, USA.
Posts: 3,069
Thanks: 0
Thanked 10 Times in 10 Posts
Default

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


Similar Threads
Thread Thread Starter Forum Replies Last Post
Access 2000 Write Conflict on Text Field seananderson Access 4 December 19th, 2006 08:45 AM
write conflict iacon VB Databases Basics 1 July 3rd, 2006 03:36 PM
Write Conflict message with SQL Server tables mmcdonal Access 3 November 18th, 2004 11:05 AM
How to write a message board with javascript ? shenliujun Javascript 0 September 5th, 2004 07:36 PM
Write Conflict in continuous Form pinkandthebrain Access 2 July 18th, 2003 11:16 AM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.