Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
SupaHoop
Starting Member
8 Posts |
 Posted - 2004-03-11 : 06:42:13
|
I have a problem in my MS Access 2000 ADP front end that queries a SQL 2000 database whereby I keep getting a Write Conflict Error. The Write Conflict brings up the following warning: If I click on Save Record, the same warning comes up, If I click on "Copy to ClipBoard" or "Drop Changes", I get the following warning box: I have looked at the MS Knowledge base Article 280730 ([url]http://support.microsoft.com/default.aspx?scid=kb;en-us;280730&Product=acc2000[/url]) and I have ensured that any bit datatypes have a default value and I have also added a timestamp to the table design, but I still get the problem.The table does have some fields with a 'real' datatype, but my understanding from the knowledge base article is that this shouldn't be an issue once I have added the time stamp.I have run a SQL Profile trace and it appears to me that the update has completed successfully. I have copied the update statement into query analyzer and run it in there. It completes OK, although no records are updated. Any help would be greatly appreciated.Cheers,Rich.____QPR's Blue & White blood runs through the veins.RTID |
|
|
drymchaser
Aged Yak Warrior
552 Posts |
Posted - 2004-03-11 : 09:27:20
|
| That happens when performing background updates in single-user environment or in a multi-user environment when someone has updated a record since you have read it.You need to write and event procedure for the Form_Error event that accepts an integer value. Have it handle error number 7787, with whatever instructions you want to give it depending on your situation and user environment.But as a caution, that procedure you write will be triggered any time a data access error occurs on that form and will need to deal with them as well. |
 |
|
|
SupaHoop
Starting Member
8 Posts |
Posted - 2004-03-11 : 12:11:33
|
| Not wishing to sound too thick, but how do I get the Form_Error to handle the error 7787?____QPR's Blue & White blood runs through the veins.RTID |
|
|
|
drymchaser
Aged Yak Warrior
552 Posts |
Posted - 2004-03-11 : 14:18:18
|
| In the forms code:sub Form_Error(DataErr as integer)if dataerr = 7787 then<code here example: resumenext, msgbox"">end ifend sub |
|
|
|
SupaHoop
Starting Member
8 Posts |
Posted - 2004-03-12 : 06:23:43
|
| Thanks for your help on this.I have found the problem !!We have another CAD application which I have found is updating the same table. It runs alongside my application.The CAD application updates just two fields on the same table and as I don't need these in my application, I have just changed my SP from Select * to Select specific records (ignoring the two fields that the CAD app is updating).____QPR's Blue & White blood runs through the veins.RTID |
|
|
|
|
|
|
|
|
Write Conflict Problem