Cotswold
Well-known member
- Local time
- Today, 20:47
- Joined
- Dec 31, 2020
- Messages
- 916
Hello All,
Although Memo Fields are probably fine now, I'd appreciate the opinions of the forum members.
Back in the dark days of DOS I found that memo fields could cause corruption. It certainly was the case using Clipper87 with dBASE tables.
When I switched to Access97 it was still the case, but then it could have been poor networks or the fact that Access doesn't just load the
record selected but a block of data, which may span several individual records and part records. I also wondered if it was maybe a bug
in Access?
My "scientific" conclusion was from the reality that Access tables in applications with Memos tended to corrupt, but those without didn't.
All systems were written with similar code developed and morphed from one application to another, using all the same libraries. After
experiencing corruption on a site, if I replaced the Memo with a text field, the corruption never happened afterwards.
I still had the odd case with Access2000, so I have always avoided their use. I would restrict a large Text field to 248 characters long.
If anyone wanted to enter more text, then the answer was always "it can't do that!"
I didn't use them in Access2010 and I am now using Access2019. I am wondering how reliable you find the Memo field, now called the
Long Text field, in current Access databases?
In a similar vein, any known issues with the Attachment type Field?
Regards, Will
Although Memo Fields are probably fine now, I'd appreciate the opinions of the forum members.
Back in the dark days of DOS I found that memo fields could cause corruption. It certainly was the case using Clipper87 with dBASE tables.
When I switched to Access97 it was still the case, but then it could have been poor networks or the fact that Access doesn't just load the
record selected but a block of data, which may span several individual records and part records. I also wondered if it was maybe a bug
in Access?
My "scientific" conclusion was from the reality that Access tables in applications with Memos tended to corrupt, but those without didn't.
All systems were written with similar code developed and morphed from one application to another, using all the same libraries. After
experiencing corruption on a site, if I replaced the Memo with a text field, the corruption never happened afterwards.
I still had the odd case with Access2000, so I have always avoided their use. I would restrict a large Text field to 248 characters long.
If anyone wanted to enter more text, then the answer was always "it can't do that!"
I didn't use them in Access2010 and I am now using Access2019. I am wondering how reliable you find the Memo field, now called the
Long Text field, in current Access databases?
In a similar vein, any known issues with the Attachment type Field?
Regards, Will