database design - Ms-Access MDB: Split Memo field into Several Text fields. (To prevent data corruption) -

I use an access database such as the back end.
I use some memo fields.

I have learned that the memo field databases are due to corruption because they are stored in a separate data page; The record only places an indicator on the data page where the actual data is stored.

Most of the time I only need 100 to 1000 characters, so I had an idea ...
Split my "brilliant" (or not) idea memorabilia into 4 or 5 text fields (They can keep 255 characters each).

Has anyone done this before?
Any known issues?
Does this approach seem to be less for data corruption?

Thanks,
Jagat

PS = 1. I have got issues of corruption.
2. I know that the best thing to do on the other back is to escape, but this is not possible.

Better dimensions Bundle the memo data page without it The attached record How to do this in a separate table To insert the memo field (s), you can either do better with a 1: 1 table (with multiple memos in the side table) or 1: N table with a memo type field. The latter methods Memo Pointer is the only way to completely avoid the problem, however, as a pre-solution, you lose all due to the corruption of a memorandum in the memo table.

In addition, you should consider why your database is corrupting memo pointers except for the above suggestions, you might consider editing your memo unbound , Although it does not seem that you are using an access front of your Jet MDB which is probably not an issue. I see memo corruption every time, but not often. If you see it often, it suggests that your application has been poorly prepared or your operating environment is clearly poor.