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
274 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 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.

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
Complete VMware vSphere® ESX(i) & Hyper-V Backup

Capture your entire system, including the host, with patented disk imaging integrated with VMware VADP / Microsoft VSS and RCT. RTOs is as low as 15 seconds with Acronis Active Restore™. You can enjoy unlimited P2V/V2V migrations from any source (even from a different hypervisor)

 

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

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

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 57

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

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

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…
Preparing an email is something we should all take special care with – especially when the email is for somebody you may not know very well. The pressures of everyday working life stacked with a hectic office environment can make this a real challen…
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 …
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…

820 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