Solved

Write Conflic - This record bas been changed by another user since you started editing it. MySQL to Access 2007

Posted on 2011-02-28
6
571 Views
Last Modified: 2012-06-21
I am using Access 2007 on a Windows 7 64 bit pc.  
I have a table linked to a MySQL database on my website.
I am using the mysql-connector-odbc-5.1.8-winx64 to connect to the database.

I am able to make the connection and see the values.

If I try to make a change I get the following error:

Write Conflict
This record bas been changed by another user since you started editing it.  If you save the record, you will overwrite the changes the other user made.

Copying the changes to the clipboard will let you look at the values the other user entered, and then paste your changes back in if you decide to make changes.

Save record not available
Copy to Clipboard and Drop Changes are available

This was working until recently.

I can connect to the MySQL table and make changes from a copy of the database running on a XP computer and a copy running on Server 2003.  No problems.

I also created a new database with the only object being the linked table.  Same problem.

Any ideas.

Thanks

Steve
0
Comment
Question by:Scamquist
  • 5
6 Comments
 
LVL 84
ID: 35003429
Often this errors comes about when you try to modify data through SQL/VBA while ALSO viewing/editing that data in a bound form. Are you doing this?

If so, then you must make changes in one place or the other, but not both (at least not at the same time). If you are using code to manipulate data that you are also working with on your form, be sure to force a save of your data by issuing this:

If Me.Dirty Then Me.Dirty = False

Even with this, you can still run into some timing issues which can result in this.

0
 
LVL 1

Author Comment

by:Scamquist
ID: 35003446
To see if it was a form issue, I created a new database with the only object being the linked table.

If I open the table, I cannot make a change to anything.

This is only on the 64 bit computer.

If I open Access 2007 and open the table on the XP or Server 2003 machine I can make changes to values in the table.

Go back to the 64 bit Windows 7 computer, open Access 2007 and open the table, the changes i made on the XP machine are there, but I still cannot change the table on the 64 bit computer.

0
 
LVL 1

Author Comment

by:Scamquist
ID: 35003472
As a further test.  I copied the Access 2007 database from the XP to the Win7 computer.  Deleted and re-linked the tables.

Same problem.  
0
Backup Your Microsoft Windows Server®

Backup all your Microsoft Windows Server – on-premises, in remote locations, in private and hybrid clouds. Your entire Windows Server will be backed up in one easy step with patented, block-level disk imaging. We achieve RTOs (recovery time objectives) as low as 15 seconds.

 
LVL 1

Author Comment

by:Scamquist
ID: 35003510
Also, at the current time, there is only one user on the database.  The backend is on the local server.  The front end is on the local PC.

Another strange thing.  There are 11 tables linked to the same MySQL database.

I am able to make changes to values in 10 of the tables.

The one in question has a date/time stamp.  
0
 
LVL 1

Accepted Solution

by:
Scamquist earned 0 total points
ID: 35003967
There appears to have been a problem with the table on the MySQL databse.

I deleted the table and re-added it.

Everything is working now.  
0
 
LVL 1

Author Closing Comment

by:Scamquist
ID: 35042820
Withdraw because I solved the problem
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Help writing a query 6 71
problems with mysql ODBC Connector and vbscript 4 25
Access Excel export not behaving 2 25
subform is not filtered by link field 8 14
QuickBooks® has a great invoice interface that we were happy with for a while but that changed in 2001 through no fault of Intuit®. Our industry's unit names are dictated by RUS: the Rural Utilities Services division of USDA. Contracts contain un…
Load balancing is the method of dividing the total amount of work performed by one computer between two or more computers. Its aim is to get more work done in the same amount of time, ensuring that all the users get served faster.
In Microsoft Access, when working with VBA, learn some techniques for writing readable and easily maintained code.
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…

919 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

Need Help in Real-Time?

Connect with top rated Experts

21 Experts available now in Live!

Get 1:1 Help Now