I have an access database that has filenames of pictures stored in it. The filenames are written as "C:\filename". I need to write a program that accesses these filenames across the network, but I cannot access "C:\Filename". I need to access "\\ComputerName\C$\filename".

How can I place the text into a varible and then delete the first two characters? I know how to append what I need to on to it.

Or if there is a better way to do it how can I do it.


Thanks
Brandon