September 19, 2006 at 10:03 am
I added a new column 'Reclaimed' attr bit(1) to a table Designs_Detail.
Now, when our programmer refreshed the Microsoft Access Links, and whatever record is changed, a dialog box appears stating 'Write Conflict'.
The dialog details 'This record has been changed by another user since your started editing it. If you save the record, you will overwrite the changes the other user made.'
Once again, this only happened since I modified the table.
Thanks for your help, Richard
September 19, 2006 at 1:52 pm
Make sure the bit-field doesn't allow nulls
September 20, 2006 at 1:02 am
Richard,
To add to Jo's reply - you should set the default value to 1 or 0.
Bits are 1 or 0 and should not be Null.
As you've added a column you should replace all records with some value.
Richie
September 20, 2006 at 6:56 am
Thank you both for your timely feedback...that fixed my issue.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply