Improve company productivity with a Business Account.Sign Up

x
?
Solved

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

Posted on 2011-03-18
10
Medium Priority
?
287 Views
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.  
0
Comment
Question by:itsupport1199
  • 5
  • 4
10 Comments
 
LVL 59
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.

JimD.
0
 
LVL 13

Expert Comment

by:Lucas
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
0
 

Author Comment

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

It happens when I try to close the form or open a new record.  
0
Easily Design & Build Your Next Website

Squarespace’s all-in-one platform gives you everything you need to express yourself creatively online, whether it is with a domain, website, or online store. Get started with your free trial today, and when ready, take 10% off your first purchase with offer code 'EXPERTS'.

 

Author Comment

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

Author Comment

by:itsupport1199
ID: 35166348
Is that enough detail? Does that help?
0
 
LVL 59
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?

JimD.
0
 

Author Comment

by:itsupport1199
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.  
0
 
LVL 59
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.

JimD.

0
 

Author Comment

by:itsupport1199
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.  
0
 
LVL 59

Accepted Solution

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

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

JimD.
0

Featured Post

Get expert help—faster!

Need expert help—fast? Use the Help Bell for personalized assistance getting answers to your important questions.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Usually, rounding is performed by some power of 10 - to thousands, hundreds, tens, or integer - or to one, two, or more decimals. But rounding can also be done to a power of two, say, 16 or 64, or 1/32 or 1/1024, even for extreme values.
With the functions here, you can parse, convert, and format back and forth between feet and inches and fractions and decimal inches - for normal as well as extreme values and with extreme precision.
Do you want to know how to make a graph with Microsoft Access? First, create a query with the data for the chart. Then make a blank form and add a chart control. This video also shows how to change what data is displayed on the graph as well as form…
Visualize your data even better in Access queries. Given a date and a value, this lesson shows how to compare that value with the previous value, calculate the difference, and display a circle if the value is the same, an up triangle if it increased…

602 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