Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win

x
?
Solved

This record has been changed by another user

Posted on 2013-10-23
4
Medium Priority
?
320 Views
Last Modified: 2013-10-24
I have a form which when closed I get a write conflict message... This record has been changed by another user, etc.

The data behind the form has been updated with a update query prior to closing the form.  I've tried DoCmd.RunCommand acCmdSaveRecord in the form's close event but that doesn't work.

How can I get rid of this message?
0
Comment
Question by:SteveL13
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
  • 2
4 Comments
 
LVL 61

Accepted Solution

by:
mbizup earned 2000 total points
ID: 39595803
If the user is able to edit data in this form, try placing your DoCmd.RunCommand acCmdSaveRecord immediately BEFORE running your update query.
0
 

Author Comment

by:SteveL13
ID: 39596996
Didn't work.  Still get Write Conflict message.
0
 
LVL 61

Expert Comment

by:mbizup
ID: 39597029
Can you post a sample database?  There are a lot of different factors that could be causing that. Without seeing your actual code/forms, it is a guessing game as to what needs to be fixed.
0
 

Author Comment

by:SteveL13
ID: 39597030
Actually this did work.  I had the line of code in the wrong place.  Thanks.
0

Featured Post

VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Access custom database properties are useful for storing miscellaneous bits of information in a format that persists through database closing and reopening.  This article shows how to create and use them.
Code that checks the QuickBooks schema table for non-updateable fields and then disables those controls on a form so users don't try to update them.
Basics of query design. Shows you how to construct a simple query by adding tables, perform joins, defining output columns, perform sorting, and apply criteria.
In Microsoft Access, learn the trick to repeating sub-report headings at the top of each page. The problem with sub-reports and headings: Add a dummy group to the sub report using the expression =1: Set the “Repeat Section” property of the dummy…

610 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question