move a file from Access

[Guest]

Is there a "move" command in Access 2007 that can be called from code that
will move a file from one folder to antother as in command line: move
c:\test\filename c:\new\

 

[raskew via AccessMonster.com]

Hi -

Try copying this to a standard module. Ensure you have a backup before
testing.

Public Sub MoveFile(psourcefile As String, ptargetfile As String)
'*******************************************
'Purpose: Moves file location
'Inputs: sourcefile, targetfile
'To Call: ? MoveFile("c:\mydocuments\all.gif", "c:\mydocuments\access\all.
gif")
'*******************************************
Dim SourceFile, DestinationFile

SourceFile = psourcefile ' Define source file name.
DestinationFile = ptargetfile ' Define target file name.
FileCopy SourceFile, DestinationFile ' Copy source to target.
Kill SourceFile

End Sub


HTH - Bob