Multiple periods in filenames getting changed to pound signs or spaces. I'm creating flat text files using the transfertext command in access VBA. The export works fine but the filename, which contains multiple periods is having all periods except the one just prior to the extension changed to a pound sign. I can live with that but I'd prefer to have more control over the filenames.
Does anyone know what is changing the filename? There are other cases where the periods are disappearing from the filename as well outside of my application and it's wreaking havoc on other processes. I'd like to make a very strong case for getting rid of the extra periods and would like your help.