Move file from inside Access

[ainow]

Is there a command that can be ran from inside Access 07 (VBA) to move a file
from one folder to another?

 

[Stuart McCall]

Is there a command that can be ran from inside Access 07 (VBA) to move a
file
from one folder to another?

Yes, if the folders are on the same drive, use the Name As statement:

Name "c:\test.txt" As "c:\MyFolder\test.txt"

If on different drives:

FileCopy "c:\test.txt", "d:\test.txt"
Kill "c:\test.txt"

 

[ainow]

Thanks, copy kill works. You just made one client very happy.
Jim