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
279 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
[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
  • 5
  • 4
10 Comments
 
LVL 58
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:lucas911
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
Salesforce Made Easy to Use

On-screen guidance at the moment of need enables you & your employees to focus on the core, you can now boost your adoption rates swiftly and simply with one easy tool.

 

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 58
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 58
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 58

Accepted Solution

by:
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.

JimD.
0

Featured Post

Salesforce Made Easy to Use

On-screen guidance at the moment of need enables you & your employees to focus on the core, you can now boost your adoption rates swiftly and simply with one easy tool.

Question has a verified solution.

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

It’s been over a month into 2017, and there is already a sophisticated Gmail phishing email making it rounds. New techniques and tactics, have given hackers a way to authentically impersonate your contacts.How it Works The attack works by targeti…
This article describes a method of delivering Word templates for use in merging Access data to Word documents, that requires no computer knowledge on the part of the recipient -- the templates are saved in table fields, and are extracted and install…
With Microsoft Access, learn how to specify relationships between tables and set various options on the relationship. Add the tables: Create the relationship: Decide if you’re going to set referential integrity: Decide if you want cascade upda…
With Microsoft Access, learn how to start a database in different ways and produce different start-up actions allowing you to use a single database to perform multiple tasks. Specify a start-up form through options: Specify an Autoexec macro: Us…

622 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