I have a single user application with an Access table :-
I load the table into a dataset (where done <> true) and, after processing set the Done field to true. this is fine as many records as I want and then I close the connection and the form.
When I next come into the form and go thru the same process it tells me that I have a concurrency error
Code:
Horseid autonum
Date datetime
Course text
Time datetime
Horse text
Done BitI load the table into a dataset (where done <> true) and, after processing set the Done field to true. this is fine as many records as I want and then I close the connection and the form.
When I next come into the form and go thru the same process it tells me that I have a concurrency error
Code:
Concurrency violation: the UpdateCommand affected 0 of the expected 1 records.
[\code]
Can anyone explain this to me please or give me a solution
Many Thanks
Jon