RE: Sudden Onset of Write Conflict
- From: "Robin Hood" <RobinHood@xxxxxxxxxxxxxxxxxxxxxxxxx>
- Date: Mon, 4 Apr 2005 10:39:10 -0700
I've been problem-solving on this, and have found two things which seem to be
factors.
First, when the recordset in question contained an ntext field, the 7787
error occurred; when I switched the data-type for that field to be an
nvarchar, everything worked as expected.
On a second form, which is functionally identical to the form I was having
problems with, but links to/from a different tables, I noticed it worked
fine. The only difference I could see is that on the form that didn't work,
I was linking an underlying value on the child form to a text box on the
parent; in the form that worked, I was linking underlying fields for both.
So make sure your linked fields aren't referring to form elements. (In other
words, rename all your controls so that there's no possibility of
overlap...RespondentID to ctlRespondentID, etc.)
Hope this works for you, as it did for me!
"Dawn Crosier" wrote:
> I have an ADP which has been in production for sometime now. Within the
> last month users are getting an error code Error 7787 Response 1 which is a
> Write Conflict error from SQL Server. This happens when they attempt to add
> an additional record to a joining table. The joining table is a dual
> primary key table with varchar 100 and varchar 50 fields. (One of each).
>
> The troubling portion of this problem, is that if the user closes down the
> main form and re-opens it. The record has been added / committed.
>
> I have other joining tables which are configured exactly the same and they
> are working with no problems. My ADP has a main form with subforms located
> on Tabs. I have 3 subforms setup exactly the same and two of them are NOT
> experiencing problems YET. The joining table which is causing problems has
> 773 records in it while the other two tables contain 138 and 132 records
> respectively.
>
> --
> Dawn Crosier
> "Education Lasts a Lifetime"
>
> This message was sent to a newsgroup. Please post back to the newsgroup so
> all may follow the thread.
>
>
>
.
- Prev by Date: RE: Sudden Onset of Write Conflict
- Next by Date: Data access pages
- Previous by thread: Re: Sudden Onset of Write Conflict
- Next by thread: RE: Sudden Onset of Write Conflict
- Index(es):
Relevant Pages
|
