Solved

This record has been changed by another user

Posted on 2013-10-23
4
313 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
  • 2
  • 2
4 Comments
 
LVL 61

Accepted Solution

by:
mbizup earned 500 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

Top 6 Sources for Identifying Threat Actor TTPs

Understanding your enemy is essential. These six sources will help you identify the most popular threat actor tactics, techniques, and procedures (TTPs).

Join & Write a Comment

Most if not all databases provide tools to filter data; even simple mail-merge programs might offer basic filtering capabilities. This is so important that, although Access has many built-in features to help the user in this task, developers often n…
It took me quite some time to sort out all the different properties of combo and list boxes available from Visual Basic at run-time. Not that the documentation is lacking: the help pages are quite thorough and well written. The problem was rather wh…
Get people started with the utilization of class modules. Class modules can be a powerful tool in Microsoft Access. They allow you to create self-contained objects that encapsulate functionality. They can easily hide the complexity of a process from…
What’s inside an Access Desktop Database. Will look at the basic interface, Navigation Pane (Database Container), Tables, Queries, Forms, Report, Macro’s, and VBA code.

705 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

Need Help in Real-Time?

Connect with top rated Experts

21 Experts available now in Live!

Get 1:1 Help Now