Hi aginell4life,
This issue can be due to encoding mismatches.
Follow below few steps to resolve this issue.
1. Make sure your connection string specifies the correct provider and includes any necessary parameters for handling Unicode.
Provider=Microsoft.ACE.OLEDB.12.0;Data Source=E:\\test.accdb;
2. When defining your database schema, make sure that text fields support Unicode. Example Long Text.
3. Make sure that the data stored in your MS Access database is correctly encoded. Data might be stored in a non-Unicode format, which can cause issues when reading it.
If you still facing issues, check your database schema and the data itself to ensure everything is correctly configured for Unicode support.