Help! Can't edit certain records; Access 2007 FE, MSSQL 2K8 BE
Posted on 2012-03-20
Hello, I've got a problem that I is somehow related to a table in my database, but I can't figure out quite how or why, or why now, after having worked well for quite a while.
When I try to edit certain records in that table, via the Access FrontEnd, I get a "Write Conflict" error, with the dreaded "Copy to clipboard" or "Drop changes" buttons. Many/most other records can be edited just fine though.
This table is right in the middle of some complex relationships; it represents a "booking" which is right in between customers, trips, and payments, so there is a lot going on... given that, how am I to find what is fighting back?
I did install the full MSSQL 2008 R2 toolset, but it doesn't look like the debugging tools are there.
Ideas, anyone, please?
Thanks in advance!