All,
In our 8,000 record ACT database, we have fields that point to folders on our server. For example, we may have a field for scanned documents. In that field might be file://S:\scans\Anderson
We now have so many folders in that directory that we need to separate them out in sub folders. So ..
file://S:\scans\Anderson
would be:
file://S:\scans\A\Anderson
(notice the subfolder A)
All we would need is a query that would go in and look for "file://S:\scans\A" and replace it with "file://S:\scans\A\A" and leave the text after it alone. We would have to do this for each letter but that would not be an issue.
(We have 5 fields like this so it manually it could be 5 x 8,000 = 40,000 records to change)
Any suggestion for an automated way of doing this?
Thanks!!
