Filecopy on 64 bit Runtime 2013 not working, is there a fix?

[henry.klassen]

I've been trying to wrap my head around this issue, the filecopy function will not work on the 2013 runtime. However in the actual MS Access application it runs fine. Has anyone else come across this? Where you able to fix it?

[ranman256]

try this usage:

Copy1File sSrc, sTarg

Public Sub Copy1File(ByVal pvSrc, ByVal pvTarg)
Dim FSO
Set FSO = CreateObject("Scripting.FileSystemObject")
FSO.CopyFile pvSrc, pvTarg
Set FSO = Nothing
End Sub

[henry.klassen]

seems this line is causing the issue [strWorkSpace = DLookup("Set_Value", "Settings", "Description =" & "'Brake_Work_Space'") & strPartNumber & "." & strFileType ]
in access I'll get a value like "c:\Work_Dir\123456.dxf", in the runtime it returns "123456.dxf"