Wrox Programmer Forums
Go Back   Wrox Programmer Forums > Microsoft Office > Access and Access VBA > Access
|
Access Discussion of Microsoft Access database design and programming. See also the forums for Access ASP and Access VBA.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Access 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 July 15th, 2003, 05:19 PM
Authorized User
 
Join Date: Jul 2003
Posts: 29
Thanks: 0
Thanked 0 Times in 0 Posts
Default Write Conflict in continuous Form

I have an Access Project that sets the RecordSource property to an SQL statement. Everything works well until I decide to change the value of a field twice ... Write Conflict, this record has been changed by another user.. etc. I'm the only User, so this should not be a problem. If I change the RecordSource property to reference an SQL Server Stored Procedure, it works. How do I get around this problem as I need to execute different SQL statements from code?
Help would be appreciated. Thanks.

 
Old July 17th, 2003, 11:51 AM
Authorized User
 
Join Date: Jun 2003
Posts: 22
Thanks: 0
Thanked 0 Times in 0 Posts
Default

I am inclinded to think the form is not updated or refreshed before you try to change it again. I would start by adding:

Code:
Me.Refresh
in the AfterChange event for the field you are changing. See if that helps. If not, I will need more details to better help trace the cause.

-Shay Shepston
 
Old July 18th, 2003, 11:16 AM
Authorized User
 
Join Date: Jul 2003
Posts: 29
Thanks: 0
Thanked 0 Times in 0 Posts
Default

I decided to go with the Stored Procedure and Parameter option, as I do not run into any update problems.






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
Continuous form / SetFocus help dbartelt Access 5 February 13th, 2006 03:59 PM
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





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