Access has stopped reading characters (é, á, ú and so forth) correctly.

Hi all,

I have a long running access Database that essentially compares two lists and reports back the differences; it's one of those things I've been meaning to automate for a long-time but without a real need to as the system worked fine.

Since the end of last week Access is now generating reports about mis-matched data that isn't correct (when viewing the data in both original sources you can see it's the same) but during the import/comparison process it's clearly losing something so it doesn't read the é correctly (reports it as ├®)

I've checked the import, I've checked the linked table in Access and it shows correctly in both of those, but when the comparison macro runs it's clearly triggering something that causes the end result to mean that the data it's pulling from the table has ├® and the master file has é and therefore it's not a match.

This has ran fine for months, so unsure if there's been a change/tweak in settings somewhere along the line? I've tried it on different systems just in case it was a local issue, but that doesn't help either.

The files are a csv (UTF-8 with BOM) and an established SQL table. Neither have had changes to their production/output in the past few months.

Any thoughts appreciated