I have 138 rows of Universal Naming Convention (UNC) paths. Part of each path is constant and part is a variable. How do I change the constant portion of the UNC path and keep the variable intact? For example: •\serverpathdir1dir11 •\serverpathdir2 •\serverpathdir3dir31 constant part...
I have many excel worksheets that link to other worksheets. Some link by drive letter mappings and others have a UNC name. Is there a way to link without using the UNC name? Concern is what to do if the linked server is changed. Do we have to go through each spreadsheet and change the link? Or...
I need some ideas here...I'm stuck. I'm running an RPG program that builds some CSV files for our accounting department. Because they love Excel, I had to make it so that the program breaks the data up into separate CSV files so as not to exceed 65,535 rows. Anyway, I am saving the stream files...
My Setup: Server A: Win2k / Access2000 Server B: Win2k3 / Access2007 I have a syncing application that will look for changes on my ServerB database, and replicate those changes to the ServerA DB. This application is based around a mapped drive. What I am trying to secure is a method that will...


