Wrox Programmer Forums
VB Databases Basics Beginning-level VB coding questions specific to using VB with databases. Issues not specific to database use will be redirected to other forums.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the VB Databases Basics 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
Old June 30th, 2006, 07:06 PM
Authorized User
Join Date: Dec 2004
Posts: 12
Thanks: 0
Thanked 0 Times in 0 Posts
Default write conflict

When I tried to execute DoCmd.Close acForm, "new_call", acSaveNo a "write conflict" message box pops up and it only occurs when the combo boxes or radio buttons change from when the form opens. Is there a way to bypass that message and discard any changes since all the record changes are finished. I just want to close the form. Here's the text of the box and the choices available:

This record has been changed by another user since you started editing it. If you save the record, you will overwrite the changes the other user made.

Copying the changes to the clipboard will let you look at the values the other user entered, then paste your changes back in if you decide to make changes.

save record
copy to clipboard
drop changes
Old July 3rd, 2006, 03:36 PM
Authorized User
Join Date: Dec 2004
Posts: 12
Thanks: 0
Thanked 0 Times in 0 Posts

I am not sure why this works, but not executing the update SQL and simply running the DoCmd.close acForm code works just fine. I am glad the code works, but would love an explanation as to exactly why it does.

Similar Threads
Thread Thread Starter Forum Replies Last Post
Difference between Trace.write and Debug.write surendraparashar ASP.NET 2.0 Professional 1 June 27th, 2007 02:12 AM
Access 2000 Write Conflict on Text Field seananderson Access 4 December 19th, 2006 08:45 AM
Write Conflict message with SQL Server tables mmcdonal Access 3 November 18th, 2004 11:05 AM
Write Conflict message mmcdonal SQL Server 2000 1 November 17th, 2004 11:39 AM
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.