We help IT Professionals succeed at work.

Access 2010 write confict on updates to records created with Access 2010 on a MS SQL 2008 backend.

RobCola
RobCola used Ask the Experts™
on
I moved the backend of a MS Access 2003 created database to a cloud DB server (MS SQL 2008). I've updated the queries and forms using MS Access 2010 to point to the cloud. Since the split, I can edit existing records and create new ones.  However, records created in MS Access 2010 can not be updated, I receive a write conflict.  I have also tried directly changing the content in the cloud throught MS Access table and have received the same error.  An update query written MSSQLSMS will work on the new query.  Restarting Access 2010 did not work.
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Scott McDaniel (EE MVE )Infotrakker Software
Most Valuable Expert 2012
Top Expert 2014

Commented:
What do you mean by a "Cloud" db server? Are you running on a true cloud (i.e. Azure, or some other platform), or are you running on some other system?

Have you defined Primary Keys on all your tables, and have those PK indexes been recognized by Access?
Retired
Commented:
<<I receive a write conflict>> Exact error? If it is something like another user has edited the record .... try adding a timestamp column to your table.

Chris B
Scott McDaniel (EE MVE )Infotrakker Software
Most Valuable Expert 2012
Top Expert 2014

Commented:
try adding a timestamp column
Good catch! I forgot about the TimeStamp column ...

Author

Commented:
The 'Cloud' Solutions is a shared SQL server provided by my Webhosting company.  I will add Timestamp and see what happens.