p2p.wrox.com Forums

Need to download code?

View our list of code downloads.


  Return to Index  

access thread: Write Conflict


Message #1 by tegrovesjr@r... on Tue, 11 Jun 2002 15:06:03
I have a form based on a join that allows the user to edit fields only on 
one table from the join (see below).  If the user edits the same column on 
a specific row twice, the user gets a Write Conflict message box.  
However, if the user nevers edits the same column on a specific row, 
meaning, if the edit every field on the screen once, then the user move 
off any field and/or close the form without an error.

I've reviewed Article Q280730 which talks about bit columns being set to 
Null.  All the columns have values on the records being edited.

Unique Table:
KYLAB_SPEC_DETAIL

Record Source:
SELECT KYLAB_LAB_TEST.TEST_NAME, KYLAB_PROPERTY.PROPERTY, 
KYLAB_SPEC_DETAIL.* FROM KYLAB_SPEC_DETAIL LEFT JOIN KYLAB_PROPERTY ON 
KYLAB_PROPERTY.PROPERTY_NO = KYLAB_SPEC_DETAIL.PROPERTY_NO LEFT JOIN 
KYLAB_LAB_TEST ON KYLAB_LAB_TEST.TEST_NO = KYLAB_SPEC_DETAIL.TEST_NO WHERE 
KYLAB_SPEC_DETAIL.SPEC_NO = '114' ORDER BY KYLAB_SPEC_DETAIL.SEQ_NO

Any suggestions.

Message #2 by "Haslett, Andrew" <andrew.haslett@i...> on Wed, 12 Jun 2002 13:50:44 +0930
Maybe try altering the 'Recordset Type' or 'Record Locks' settings of the
Form properties (Data Tab).

Do you have any other events running on the form (eg. After_Update etc.)?

Cheers,
Andrew

-----Original Message-----
From: tegrovesjr@r... [mailto:tegrovesjr@r...]
Sent: Wednesday, 12 June 2002 12:36 AM
To: Access
Subject: [access] Write Conflict


I have a form based on a join that allows the user to edit fields only on 
one table from the join (see below).  If the user edits the same column on 
a specific row twice, the user gets a Write Conflict message box.  
However, if the user nevers edits the same column on a specific row, 
meaning, if the edit every field on the screen once, then the user move 
off any field and/or close the form without an error.

I've reviewed Article Q280730 which talks about bit columns being set to 
Null.  All the columns have values on the records being edited.

Unique Table:
KYLAB_SPEC_DETAIL

Record Source:
SELECT KYLAB_LAB_TEST.TEST_NAME, KYLAB_PROPERTY.PROPERTY, 
KYLAB_SPEC_DETAIL.* FROM KYLAB_SPEC_DETAIL LEFT JOIN KYLAB_PROPERTY ON 
KYLAB_PROPERTY.PROPERTY_NO = KYLAB_SPEC_DETAIL.PROPERTY_NO LEFT JOIN 
KYLAB_LAB_TEST ON KYLAB_LAB_TEST.TEST_NO = KYLAB_SPEC_DETAIL.TEST_NO WHERE 
KYLAB_SPEC_DETAIL.SPEC_NO = '114' ORDER BY KYLAB_SPEC_DETAIL.SEQ_NO

Any suggestions.


  Return to Index