Access tells me the record was changed by another user when I'm the only accessing the record

Posted on 2011-03-18
Last Modified: 2012-05-11
I have an Access 2010 front end with a SQL server 2005 backend.  I am trying to update from a form that is based on an updateable query based on two tables.  

When I try to edit a record I get the standard message that the record has been edited by another user and the only options given are to drop the changes or copy them to clip board.  It doesn't give me an option to override.  

I am the only person accessing the record at that time since I'm working on a develop application.,

Help please.  
Question by:itsupport1199
  • 5
  • 4
LVL 57
ID: 35166313

 Does this record include a memo field formatted as rich text?  If so, it's a bug.  As soon as the field gets beyond 350 characters (approx), you'll get the error no matter what.

  If that's not the case, fill in some more details on how and when this occurs.

LVL 13

Expert Comment

ID: 35166330
Are you updating a record in SQL prior to saving it?

I've had the same situation where i did an update statement and once the form got focus it got this message.  

Prior to updating or inserting a record via SQL you should run the save record command.

Docmd.RunCommand accmdSaveRecord

Author Comment

ID: 35166335
No, it doesn't include a memo field.

It happens when I try to close the form or open a new record.  

Author Comment

ID: 35166341
No.  I'm not updating from SQL.

Author Comment

ID: 35166348
Is that enough detail? Does that help?
What Is Threat Intelligence?

Threat intelligence is often discussed, but rarely understood. Starting with a precise definition, along with clear business goals, is essential.

LVL 57
ID: 35166668

 Need a little more.  Was this working before or is it a new setup?  Are you you using linked tables?  If so, can you edit the record directly on the the linked table?   If so, can you edit the record in the query directly that the form is based on?


Author Comment

ID: 35166738
It's a new form in an existing application.  I just tried and I can't edit any records in either the query or the two tables the query is based on.  
LVL 57
ID: 35167346
<<It's a new form in an existing application.  I just tried and I can't edit any records in either the query or the two tables the query is based on. >>

  OK, so it's nothing in the form then, but something in the table design.  Is this a new table then?  

  With SQL Server as a backend there are a few data types that will give you trouble.  First though, make sure the table has a unique index on it.

 Second thing to check is for bit fields; you must make sure you give a default value if there is one.  Also check the text fields, they should be VARCHAR.

  Check those out and then test again using the table directly.  Once that works check the query, then the form.



Author Comment

ID: 35167742
All the text field were set to varchar. Some of the bit fields didn't have default values so I changed all those to default to false.

It's still giving me the error, unfortunately, though when I try to edit the tables directly.  
LVL 57

Accepted Solution

Jim Dettman (Microsoft MVP/ EE MVE) earned 250 total points
ID: 35175500

 Try adding a time stamp field to the table.  Rounding on floating point fields can also lead to problems.


Featured Post

Do You Know the 4 Main Threat Actor Types?

Do you know the main threat actor types? Most attackers fall into one of four categories, each with their own favored tactics, techniques, and procedures.

Join & Write a Comment

Introduction The Visual Basic for Applications (VBA) language is at the heart of every application that you write. It is your key to taking Access beyond the world of wizards into a world where anything is possible. This article introduces you to…
I see at least one EE question a week that pertains to using temporary tables in MS Access.  But surprisingly, I was unable to find a single article devoted solely to this topic. I don’t intend to describe all of the uses of temporary tables in t…
As developers, we are not limited to the functions provided by the VBA language. In addition, we can call the functions that are part of the Windows operating system. These functions are part of the Windows API (Application Programming Interface). U…
Learn how to number pages in an Access report over each group. Activate two pass printing by referencing the pages property: Add code to the Page Footers OnFormat event to capture the pages as there occur for each group. Use the pages property to …

743 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

13 Experts available now in Live!

Get 1:1 Help Now