Here are some lenghty threads that may be relevant.
In this the user is trying to import files with unicode characters in the name. Although Windows excepts these, neither Acess SQL or vba string functions do
Hello All I'm not bad on Microsoft Access but I am quite new on VBA codes. I spent almost 24 hours to get solution below. I have several csv files I am importing them to table with bellowing code: Dim FSO As Object, objFolder As Object, objFile As Object Set FSO =...
www.access-programmers.co.uk
The solution was to strip these characters before importing and rename the file
In a similar instance the OP was spanning the file directory and logging files with unicode characters. Windows excepts these characters, and you can store them in the DB as you show. Again you cannot do SQL on these characters, so you cannot search for them.
In this the
See demo. I used module level variables, it was the simplest but maybe not the cleanest way.
www.access-programmers.co.uk
So some of the suggestions use a replace function for other characters not handled by SQL.
However, I am confused on your issue. Because what the above shows was that the file name can handle these characters and these characters can also be stored in the table. You are not doing SQL or access string searches on these. So I would think it would work and there should be no issue with renaming using a unicode character.
Can you provide your renaming code?