Hello
I have a big problem with Access databases when two are using/updating one database at the same time.
I have seen that more and more datasets are getting corrupt (this means that in the field with the error stands the text #Error#)and the information stored in this field is lost. And then because of these errors sometimes it happens that the whole database needs to be repaired. So I have seen the errors only happen in memo fields so does anybody know how I can avoid these errors in the future or give me some other usefull hints about handling memofields in databases? When I am talking about two people are updating data in the same database I am not saying that they are changing the same datasets because then I would understand that there are errors.
Kind regards
Robert
I have a big problem with Access databases when two are using/updating one database at the same time.
I have seen that more and more datasets are getting corrupt (this means that in the field with the error stands the text #Error#)and the information stored in this field is lost. And then because of these errors sometimes it happens that the whole database needs to be repaired. So I have seen the errors only happen in memo fields so does anybody know how I can avoid these errors in the future or give me some other usefull hints about handling memofields in databases? When I am talking about two people are updating data in the same database I am not saying that they are changing the same datasets because then I would understand that there are errors.
Kind regards
Robert
