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

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.  
itsupport1199Asked:
Who is Participating?

[Webinar] Streamline your web hosting managementRegister Today

x
 
Jim Dettman (Microsoft MVP/ EE MVE)Connect With a Mentor PresidentCommented:

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

JimD.
0
 
Jim Dettman (Microsoft MVP/ EE MVE)PresidentCommented:

 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
 
LucasMS Dynamics DeveloperCommented:
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
Never miss a deadline with monday.com

The revolutionary project management tool is here!   Plan visually with a single glance and make sure your projects get done.

 
itsupport1199Author Commented:
No, it doesn't include a memo field.

It happens when I try to close the form or open a new record.  
0
 
itsupport1199Author Commented:
No.  I'm not updating from SQL.
0
 
itsupport1199Author Commented:
Is that enough detail? Does that help?
0
 
Jim Dettman (Microsoft MVP/ EE MVE)PresidentCommented:

 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
 
itsupport1199Author Commented:
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
 
Jim Dettman (Microsoft MVP/ EE MVE)PresidentCommented:
<<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
 
itsupport1199Author Commented:
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
All Courses

From novice to tech pro — start learning today.