07-31-2011 11:24 AM
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 ..
(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?
08-01-2011 08:09 AM
If you go to Designr1.com they have an addin swiss army knife whihc I believe is capable of this change