Ever simply needed to rename a file? Well, once again there are a multitude of ways to accomplish this within MS Access. I have seen numerous postings suggest using a scripting object and then copy the file while renaming the copied version. To me, if all you need is to rename the file, this is a uselessly complicated method. Instead why not simply use the Name function? It can all be accomplished in one clean line of code!!!
Name "C:\OldFileName" AS "C:\NewFileName"
Actually, you can even use the Name command to move and rename a file simultaneously.
Name "C:\OldDir\OldFileName" AS "C:\NewDir\NewFileName"
As you can see this is another versatile command to be aware of.
Current average ratings.