[MSAccessProfessionals] problem wit collecting file names

Hi friends, an  ion particulat Crystal)

I make good use of  crystal's code to  reasdd filenames into an access table.
And this works fine and fast..
 However, when I want to access the files later, using the stored fullpath,
I get errors, when an special character was in the filename. This is an example:

E:\exchange\complete\The Wire Tapper 11\15. un caddie renvers� dans l~herbe - www.nonphilo.org.mp3

NB: Note: I already replace  ' with  ~ to avoid  problems when I use SQL code  where single quotes  are used as delimiters.

So, I have  two questions,
1: Is there a way to store the filenames in such a way  that they can be opened by the name that is stored?
2, I this is not so simple, is there a way to detect these names with  special characters,  so that I can write a routine to replace them on the fly?
 
Kind regards, Onno Knol

_._,_._,_

---

Groups.io Links:

You receive all messages sent to this group.

View/Reply Online (#115635) | Reply To Group | Reply To Sender | Mute This Topic | New Topic

Your Subscription | Contact Group Owner | Unsubscribe [sugeng.panjalu.access@blogger.com]

_._,_._,_