Jump to content
  • Checkout
  • Login
  • Get in touch


The e-commerce.

Can't edit Products table via ODBC?


Recommended Posts

I'm reposting this so I don't give the impression I have solved my own problem.


I'm using the ODBC driver and linking to tables via Access, I'm able to edit data in most tables, but the products table is not allowing it. I can begin the edit process, but when I try to move to another record (which would normally trigger the record save), I get an error message:




Write Conflict

This record has 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 if you decide to make changes.



Then, it gives me 3 buttons:

- Save Record

- Copy to Clipboard

- Drop Changes


I would love to click on Save Record, but it's grayed out, disabled, useless. Any ideas why this is happening?


I should mention that I've relinked to the table with no success. I'm assuming that there is an open record in the products table on the website somehow, but I don't know how to close this.


Additionally, I've tried recreating the products_last_modified field, thinking there was a timestamp issue here (saw this as a suggested solution in an old newsgroup posting). This didn't work at all.


Any clues would be greatly appreciated.



Link to comment
Share on other sites

OK, I couldn't wait for a friendly response anymore, so I had to solve my own probelem. I actually found the solution on another forum: http://forums.devarticles.com/t9007/s.html.


Basically, the solution is to add a timestamp to the table, and Access (or other front ends using the ODBC connection) will not assume multiple connections to the table. For the full explanation, see the link above.


Thanks for all the help to...uh...myself.


Seriously, I hope this helps others.

Link to comment
Share on other sites


This topic is now archived and is closed to further replies.

  • Create New...