nFP = \\nw\data\NWI&DS_FTI\AP-Data\
strFile = nFP & Left(rs.Fields("APDBMS_DB"), 3)
strFile value returns as -
I need to replace via code the drive letter to the UNC. the string with the original filepath is stored with a drive letter and cannot be changed in the data. I need to convert the drive letter into the proper UNC via concatenation.
What am I doing wrong - I tried both Left and LTRIM - without success.